注意事项:
1. 创建表时候, 一定要为表设置 “主键”
2. DataTable data 中是已经修改好的数据
OpenSql(); // 打开数据库
SQLiteCommand cmd = m_dbConnection.CreateCommand();
SQLiteTransaction trans = m_dbConnection.BeginTransaction();
try
{
cmd.CommandText = "SELECT * FROM Codes_EXC";
SQLiteDataAdapter oda = new SQLiteDataAdapter(cmd);
SQLiteCommandBuilder ocb = new SQLiteCommandBuilder(oda);
oda.InsertCommand = ocb.GetInsertCommand();
oda.DeleteCommand = ocb.GetDeleteCommand();
oda.UpdateCommand = ocb.GetUpdateCommand();
oda.Update(data);
trans.Commit();
CloseSql();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误");
trans.Rollback();
CloseSql();
}