当DataTable数据表被更改时,只需要连接数据库字符串和Select语句就可以将当前表更新到数据源,具体做法如下:
conn = new OleDbConnection(m_connectionStringDict[dt.TableName]);
conn.Open();
adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(string SelectString); //类似"Select * From " + dt.TableName
adapter.SelectCommand.Connection = conn;
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter); //创建更新语句
try{
adapter.Update(dt.GetChanges()); //根据表的状态(插入,删除或修改)进行更新,注意删除和修改更新要求dt表中定义有主键,否则必须自定义更新语句
dt.AcceptChanges();
}catch(Exception e)
{
dt.RejectChanges();
}
adapter.Dispose();
conn.Close();
conn.Dispose();