DataTable dtChanges = dataSet1.Tables[tableName].GetChanges();
if(dtChanges != null && dtChanges.HasErrors == false)
{
OleDbDataAdapter da=new OleDbDataAdapter(selectCmdText,conn);
OleDbCommandBuilder cb=new OleDbCommandBuilder(da);
da.Update(dtChanges);
dataSet1.Merge(dtChanges);
dataSet1.Tables[tableName].AcceptChanges();
}
if(dtChanges != null && dtChanges.HasErrors == false)
{
OleDbDataAdapter da=new OleDbDataAdapter(selectCmdText,conn);
OleDbCommandBuilder cb=new OleDbCommandBuilder(da);
da.Update(dtChanges);
dataSet1.Merge(dtChanges);
dataSet1.Tables[tableName].AcceptChanges();
}
SQL语句是动态生成的,没法Write出来吧,我看看有没有相关属性先To SimonSnow(西门雪):
我的方法应该和你的差不多,只不过你用了GetChanges(),我试试看再说To alongman(alongman):
这个我倒没有注意看,我也检查先