Gets or sets an SQL statement or stored procedure used to update records in the data source.
Syntax
[System.ComponentModel.DefaultValue(null)]
public OdbcCommand UpdateCommand { set; get; }
Value
Documentation for this section has not yet been entered.
Remarks
When OdbcDataAdapter.UpdateCommand is assigned to a previously created System.Data.Odbc.OdbcCommand, the System.Data.Odbc.OdbcCommand is not cloned. Instead, the OdbcDataAdapter.UpdateCommand maintains a reference to the previously created System.Data.Odbc.OdbcCommand object.
During an update operation, if OdbcDataAdapter.UpdateCommand is not set and primary key information is present in the System.Data.DataSet, you can use the System.Data.Odbc.OdbcCommandBuilder class to automatically generate OdbcDataAdapter.UpdateCommand, and additional commands needed to reconcile the System.Data.DataSet to the data source. To do this, set the OdbcDataAdapter.SelectCommand property of the System.Data.Odbc.OdbcDataAdapter. The generation logic also requires key column information to be present in the System.Data.DataSet. For more information, see Automatically Generating Commands.
If execution of this command returns rows, these rows may be merged with the System.Data.DataSet depending upon how you set the OdbcCommand.UpdatedRowSource property of the System.Data.Odbc.OdbcCommand object.
Requirements
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0