首先建立数据库的连接
然后写SQL语句确认需要获取的字段
string connStr = "server=.;database=MedicineCabinet;Integrated Security=True;";
SqlConnection conn = new SqlConnection(connStr);//新建连接对象
conn.Open();//用于打开数据库连接
SqlCommand Command = conn.CreateCommand();
Command.CommandText = "Select Drug_name,MKe_num,Pian_num,Weight from average";//SQL语句
SqlDataReader myReader = Command.ExecuteReader();
myReader.Read();
textBox1.Text = Convert.ToString(myReader["MKe_num"]);
textBox2.Text = Convert.ToString(myReader["Drug_name"]);//读取数据库中的指定字段的内容
myReader.Close();//停止读取
conn.close();//关闭数据库连接
为了方便复制直接看下面这个就行
string connStr = "server=.;database=MedicineCabinet;Integrated Security=True;";
SqlConnection conn = new SqlConnection(connStr);//新建连接对象
conn.Open();//用于打开数据库连接
SqlCommand Command = conn.CreateCommand();
Command.CommandText = "Select Drug_name,MKe_num,Pian_num,Weight from average";//SQL语句
SqlDataReader myReader = Command.ExecuteReader();
myReader.Read();
textBox1.Text = Convert.ToString(myReader["MKe_num"]);
textBox2.Text = Convert.ToString(myReader["Drug_name"]);//读取数据库中的指定字段的内容
myReader.Close();//停止读取
conn.close();//关闭数据库连接