C#怎么从数据库中得到一个字段的值

贴代码：大家请看！SqlConnection conn = new SqlConnection();conn.ConnectionString = connectionString;conn.Open();//数据库的连接SqlCommand cmd = conn.CreateCommand();...

必须掂水

2160人浏览 · 2020-03-14 20:14:01

必须掂水 · 2020-03-14 20:14:01 发布

贴代码：大家请看！

SqlConnection conn = new SqlConnection();
            conn.ConnectionString = connectionString;
            conn.Open();//数据库的连接
            SqlCommand cmd = conn.CreateCommand();          
            string local_time = DateTime.Now.ToString();
            string lname = txt2.Text.ToString();         
            SqlDataAdapter sda = new SqlDataAdapter("select *from books WHERE LNAME='" + lname + "'", conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            string condition = ds.Tables[0].Rows[0]["LCONDITION"].ToString().Trim();//Row表示第几行，
            ["LCONDITION"]表示我要得到的字段！