DbDataAdapter.SelectCommand Property

public:
 property System::Data::Common::DbCommand ^ SelectCommand { System::Data::Common::DbCommand ^ get(); void set(System::Data::Common::DbCommand ^ value); };

[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand? SelectCommand { get; set; }

[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand SelectCommand { get; set; }

[<System.ComponentModel.Browsable(false)>]
member this.SelectCommand : System.Data.Common.DbCommand with get, set

Public Property SelectCommand As DbCommand

Property Value

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

Attributes

BrowsableAttribute

Examples

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

public static OleDbDataAdapter CreateCustomerAdapter(
 OleDbConnection connection)
{
 OleDbDataAdapter adapter = new OleDbDataAdapter();
 OleDbCommand command;

 // 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;
}

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

 Dim adapter As 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

See also

• Manipulating Data (ADO.NET)
• DbProviderFactories (ADO.NET)
• ADO.NET Overview