.net中如何把sql查询的某一个键提出来

显示全部楼层 · 2009-8-11 09:07:07

你方法用错了，你希望查询出一条信息里面的某一个值应该使用SqlDataReader。
string name = this.TxtId.Text.ToString();
string pass = this.TxtPassWord.Text.ToString();
SqlConnection con = new SqlConnection("Server=.;uid =Sa;pwd ='';database=Customer;");
con.Open;
string sql1 = "select * from Customer w...

千问 · 2009-8-11 09:07:07

string name = this.TxtId.Text.ToString();
string pass = this.TxtPassWord.Text.ToString();
SqlConnection con = new SqlConnection("Server=.;uid =Sa;pwd ='';...

千问 · 2009-8-11 09:07:07

用Dataset就可以，下面是例程： SqlConnection conn = new SqlConnection(connectionString); SqlDataAdapter a = new SqlDataAdapter("select myName, myId from mytable;",conn); DataSet s = ...