dataset使用update更新数据库问题

[在坚持几年]

SqlConnection myConn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;User ID=sa; password=123");
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand("select * from aa where 1=0", myConn);
DataSet rt = new DataSet();
myDataAdapter.Fill(rt);
this.dataGridView1.DataSource = rt.Tables[0];
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter);
rt.AcceptChanges();
myDataAdapter.Update(rt);
数据库表aa应该是没有数据了，为什么没有效果呢
还是原来的数据

[marvelstack]

参考ADO.NET中的多数据表操作
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx

[amandag]

SqlConnection myConn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;User ID=sa; password=123");
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand("select * from aa where 1=0", myConn);
DataSet rt = new DataSet();
myDataAdapter.Fill(rt);
this.dataGridView1.DataSource = rt.Tables[0];
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter);
myDataAdapter.Update(rt);
rt.AcceptChanges();

先Update

[silvering]

SqlConnection myConn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;User ID=sa; password=123"); 
SqlDataAdapter myDataAdapter = new SqlDataAdapter(); 
myDataAdapter.SelectCommand = new SqlCommand("select * from aa where 1=0", myConn); 
DataSet rt = new DataSet(); 
myDataAdapter.Fill(rt); 
this.dataGridView1.DataSource = rt.Tables[0]; 
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter); 
myDataAdapter.Update(rt); 
rt.AcceptChanges(); 

还有一种方法就是把dataGridView解除绑定，再绑定一次。

[王熙伟]

SqlConnection myConn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;User ID=sa; password=123");
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand("select * from aa where 1=0", myConn);
DataSet rt = new DataSet();
rt.Clear();
myDataAdapter.Fill(rt);
this.dataGridView1.DataSource = rt.Tables[0];
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter);
rt.AcceptChanges();
myDataAdapter.Update(rt);

[在坚持几年]

楼上的几位提供的方法都不好用啊，我表aa有主键啊，为什么还是不好使呢

[在坚持几年]

有人可以替解决一下吗，分不够可以再加，急用！

[wjp_116]

本人系超级菜鸟，也来说一句，不对的话望大家多指教
楼主的DataSet不是类型化的DataSet，那么SqlDataAdapter 的updateCommand 是不是也得自己指定啊