Gets or sets an SQL statement or stored procedure used to insert new records into the data source.
Syntax
[System.ComponentModel.DefaultValue(null)]
public OleDbCommand InsertCommand { set; get; }
Value
Documentation for this section has not yet been entered.
Remarks
During System.Data.Common.DbDataAdapter.Update(System.Data.DataSet), if this property is not set and primary key information is present in the System.Data.DataSet, the OleDbDataAdapter.InsertCommand can be generated automatically if you set the OleDbDataAdapter.SelectCommand property and use the System.Data.OleDb.OleDbCommandBuilder. Then, any additional commands that you do not set are generated by the System.Data.OleDb.OleDbCommandBuilder. This generation logic requires key column information to be present in the System.Data.DataSet. For more information, see Automatically Generated Commands.
When OleDbDataAdapter.InsertCommand is assigned to a previously created System.Data.OleDb.OleDbCommand, the System.Data.OleDb.OleDbCommand is not cloned. The OleDbDataAdapter.InsertCommand maintains a reference to the previously created System.Data.OleDb.OleDbCommand object.
If execution of this command returns rows, these rows may be added to the System.Data.DataSet depending on how you set the OleDbCommand.UpdatedRowSource property of the System.Data.OleDb.OleDbCommand object.
Requirements
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0