string sqlno="select id from aa where name='bb'"; SqlConnection conn = new SqlConnection("Data Source=192.168.1.8;Initial Catalog=Test;User ID=sa;Password=191919"); SqlCommand cmd = new SqlCommand(sqlno, conn); conn.Open(); SqlDataReader da = cmd.ExecuteReader(); while (da.Read()) { textbox1.text=da[0].ToString(); } conn.Close();
string sqlno="select id from aa where name='bb'";
SqlConnection conn = new SqlConnection("Data Source=192.168.1.8;Initial Catalog=Test;User ID=sa;Password=191919");
SqlCommand cmd = new SqlCommand(sqlno, conn);
conn.Open();
SqlDataReader da = cmd.ExecuteReader();
while (da.Read())
{
textbox1.text=da[0].ToString();
}
conn.Close();
正解。但是透过楼主的问题,建议楼主学习.NET中的ADO.NET部分。希望对楼主有帮助。Connection对象
Command对象
DataReader对象
DataSet对象
DataAdapter对象
ADO.NET操作数据
ADO.NET总结