c# sqlite 批量修改

注意事项：

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();
            }