Export (0) Print
Expand All

DbDataAdapter.InsertCommand Property

Gets or sets a command used to insert new records into the data source.

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

'Declaration
<BrowsableAttribute(False)> _
Public Property InsertCommand As DbCommand

Property Value

Type: System.Data.Common.DbCommand
A 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 will be automatically generated.

The following example creates the derived class OleDbDataAdapter and sets some of its properties.

Public Shared Function CreateCustomerAdapter( _
    connection As OleDbConnection) As OleDbDataAdapter 

    Dim adapter As OleDbDataAdapter = New OleDbDataAdapter()
    Dim command As OleDbCommand

    ' Create the SelectCommand.
    command = New OleDbCommand("SELECT CustomerID FROM Customers " & _
        "WHERE Country = ? AND City = ?", connection)

    command.Parameters.Add("Country", OleDbType.VarChar, 15)
    command.Parameters.Add("City", OleDbType.VarChar, 15)

    adapter.SelectCommand = command

    ' Create the InsertCommand.
    command = New OleDbCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
        "VALUES (?, ?)", connection)

    command.Parameters.Add( _
        "CustomerID", OleDbType.Char, 5, "CustomerID")
    command.Parameters.Add( _
        "CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.InsertCommand = command
    Return adapter
End Function

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft