这样只能显示,不能更新数据库
我的问题和你的差不多
http://expert.csdn.net/Expert/topic/2852/2852851.xml?temp=.121258关注***************
我的问题和你的差不多
http://expert.csdn.net/Expert/topic/2852/2852851.xml?temp=.121258关注***************
调试欢乐多
DataSet DS_old = new DataSet();
//DS_old 获取一个表的数据集(select * from table1)
............
现在的问题是如何将DS_old的数据集直接更新到另一个表(table2)中去,table2比table1多一个字段。可以按照主键进行判断,没有则插入数据,有则更新数据。请公主等其他高手们帮助我们解决这个问题吧,我们将不胜感激!!!!!
OleDbCommandBuilder cb = new OleDbCommandBuilder(MyAdapter);
MyAdapter.Update(ds_1,"Customers");
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter);
myConn.Open();
DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS, "Customers");
//code to modify data in dataset here.....用custDS和你的dataset合并,主意结构 //Without the SqlCommandBuilder this line would fail
myDataAdapter.Update(custDS, "Customers");
myConn.Close();