DbDataAdapter.SelectCommand Property

 

Gets or sets a command used to select records in the data source.

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

<BrowsableAttribute(False)>
Public Property SelectCommand As DbCommand

Property Value

Type: System.Data.Common.DbCommand

A IDbCommand that is used during Update to select records from data source for placement in the data set.

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 * 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
Available since 2.0
Return to top
Show: