Export (0) Print
Expand All

IDbDataAdapter.InsertCommand Property

Gets or sets an SQL statement used to insert new records into the data source.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)

function get InsertCommand () : IDbCommand 
function set InsertCommand (value : IDbCommand)

Property Value

Type: System.Data.IDbCommand
An IDbCommand used during Update to insert records in the data source for new rows in the data set.

During Update, if this property is not set and primary key information is present in the DataSet, the InsertCommand can be generated automatically if you set the SelectCommand property of a .NET Framework data provider. Then, any additional commands that you do not set are generated by the CommandBuilder. This generation logic requires key column information to be present in the DataSet. For more information see Generating Commands with CommandBuilders (ADO.NET).

When InsertCommand is assigned to a previously created IDbCommand, the IDbCommand is not cloned. The InsertCommand maintains a reference to the previously created IDbCommand object.

NoteNote:

If execution of this command returns rows, these rows may be added to the DataSet depending on how you set the UpdatedRowSource property of the IDbCommand object.

The following example creates an instance of the inherited OleDbDataAdapter class, and sets the SelectCommand and InsertCommand properties. It assumes you have already created an OleDbConnection object.

No code example is currently available or this language may not be supported.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360, Zune

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 3.5, 2.0, 1.0

XNA Framework

Supported in: 3.0, 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft