C#Winform中怎样用SqlDataAdapter把绑定到TextBox的数据更新到数据库
从数据库中用SqlDataAdapter去的DataTable后,我把这张表绑定到了几个TextBox中,发现一个问题:
通过textBox更新的值等反应到DataTable中,但是无法更新到数据库中,但是如果绑定到dataGridView就可以
private void button1_Click(object sender, EventArgs e)
         {
             SqlDataAdapter1 = new SqlDataAdapter("select * from test",DatabaseManager.getConn());
             SqlDataAdapter1.Fill(Table1);
             textBox1.DataBindings.Add("Text",Table1,"ID");   //绑定到textBox
             textBox2.DataBindings.Add("Text", Table1, "Names");
             textBox3.DataBindings.Add("Text", Table1, "vvv");
         }
         private void button2_Click(object sender, EventArgs e)
         {
                   for (int i = 0; i < 3; i++)  //这里确认了,TextBox的值确实提交到了DataTable中
                 Console.WriteLine(Table1.Rows[0][i].ToString());
             SqlCommandBuilder b = new SqlCommandBuilder(SqlDataAdapter1);
             SqlDataAdapter1.Update(Table1);
         }
------解决方案--------------------
textBox1.DataBindings.Add("Text",myTable,"id");
textBox1.DataBindings["Text"].WriteValue();
myCurrencyManager = (CurrencyManager)this.BindingContext[myTable];
myCurrencyManager.Position = 0;
dataGrid1.DataSource=myTable;