con = new SqlConnection("server=localhost;database=stock;uid=sa;pwd=5454");
con.Open();
ada = new SqlDataAdapter("select * from login",con);
ds=new DataSet();
ada.Fill(ds,"login");
this.dataGrid1.DataSource=ds.Tables["login"].ToString();
this.textBox1.DataBindings.Add("Text",ds,"login.name");
this.textBox2.DataBindings.Add("Text",ds,"login.password");
this.checkBox1.DataBindings.Add("Checked",ds,"login.type");
=====================
this.textBox1.DataBindings.Add("Text",ds,"login.name");这句出了错,说“复杂的 DataBinding 接受 IList 或 IListSource 作为数据源”。
ada=new SqlDataAdapter();
ada.SelectCommand=new SqlCommand("select * from login",con);还有this.dataGrid1.DataSource=ds.Tables["login"].ToString();
改成:this.dataGrid1.DataSource=ds.Tables["login"];
ada=new SqlDataAdapter();
ada.SelectCommand=new SqlCommand("select * from login",con);
与
ada = new SqlDataAdapter("select * from login",con);具体有什么区别呢?
ada = new SqlDataAdapter("select * from login",con);
ada .SelectCommand=SqlCommand("select * from login");比较起来,当然我写的要简单点啊...
具体看下MSDN吧,以SqlDataAdapter为关键字....
this.dataGrid1.DataSource=ds.Tables["login"].ToString();
改成:this.dataGrid1.DataSource=ds.Tables["login"];DataSource应该是"login"表,而不是字符串....