下面的语句中ads中是数据已经改变,但是更新没有作用
SqlDataAdapter sqlAdp = new SqlDataAdapter( "SELECT * FROM T_storehouse" , sconn) ;
OleDbDataAdapter accessAdp = new OleDbDataAdapter( "SELECT * FROM T_storehouse" , aconn) ;OleDbCommandBuilder cb = new OleDbCommandBuilder(accessAdp);
DataSet ads = new DataSet ( ) ;
DataSet sds = new DataSet ( ) ;sqlAdp.Fill(sds,"T_storehouse");
accessAdp.Fill(ads,"T_storehouse");ads = sds;
accessAdp.Update(ads,"T_storehouse");
SqlDataAdapter sqlAdp = new SqlDataAdapter( "SELECT * FROM T_storehouse" , sconn) ;
OleDbDataAdapter accessAdp = new OleDbDataAdapter( "SELECT * FROM T_storehouse" , aconn) ;OleDbCommandBuilder cb = new OleDbCommandBuilder(accessAdp);
DataSet ads = new DataSet ( ) ;
DataSet sds = new DataSet ( ) ;sqlAdp.Fill(sds,"T_storehouse");
accessAdp.Fill(ads,"T_storehouse");ads = sds;
accessAdp.Update(ads,"T_storehouse");
accessAdp.Update()时是根据行的状态进行更新的你看看ads有没有行的状态是修改的
这样写太嚣张了吧!还是把记录一条一条add进去,再用Update ()