Assembly: System.Data (in system.data.dll)
'Declaration Property SelectCommand As IDbCommand 'Usage Dim instance As IDbDataAdapter Dim value As IDbCommand value = instance.SelectCommand instance.SelectCommand = value
/** @property */ IDbCommand get_SelectCommand () /** @property */ void set_SelectCommand (IDbCommand value)
function get SelectCommand () : IDbCommand function set SelectCommand (value : IDbCommand)
Property ValueAn IDbCommand that is used during Update to select records from data source for placement in the data set.
When SelectCommand is assigned to a previously created IDbCommand, the IDbCommand is not cloned. The SelectCommand maintains a reference to the previously created IDbCommand object.
If the SelectCommand does not return any rows, no tables are added to the DataSet, and no exception is raised.
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.
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
Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.