110,536
社区成员
发帖
与我相关
我的任务
分享
public DataTable UpdateByDataSet(DataTable dt, string strTblName)
{
OleDbCommand myCommand = new OleDbCommand(("select * from " + strTblName), DataBase.Con);
OleDbDataAdapter myAdapter = new OleDbDataAdapter(myCommand);
OleDbCommandBuilder myCommandBuilder = new OleDbCommandBuilder(myAdapter);
myCommandBuilder.RefreshSchema();
myAdapter.InsertCommand = myCommandBuilder.GetInsertCommand();
myAdapter.UpdateCommand = myCommandBuilder.GetUpdateCommand();
myAdapter.DeleteCommand = myCommandBuilder.GetDeleteCommand();
try
{
lock (this) //处理并发情况(分布式情况)
{
myAdapter.Update(dt);
}
return dt; //数据集的行状态在更新后会都变为: UnChange,在这次更新后客户端要用返回的dt
}
catch (Exception e)
{
throw (e);
}
}