OdbcCommand command = new OdbcCommand(string.Format("select * from TABLE where ID_PAR = '{0}'", Id), Connection.GetConnection(database));
OdbcDataAdapter adapter = new OdbcDataAdapter(command);
OdbcCommandBuilder commandBuilder = new OdbcCommandBuilder(adapter);
adapter.UpdateCommand = commandBuilder.GetUpdateCommand();
如何仅在 ID_PAR 上使用 WHERE 条件使 commandBuilder 返回命令
UPDATE TABLE SET COLUMN_1 = ?, COLUMN_2 = ? WHERE ID_PAR = ?
当前返回这样的命令
UPDATE TABLE SET COLUMN_1 = ?, COLUMN_2 = ? WHERE ((ID_PAR = ?) AND (COLUMN_1 = ?) AND (COLUMN_2 = ?))
将属性设置
ConflictOption为OverwriteChanges。