OracleDataAdapter.SelectCommand Property (System.Data.OracleClient)

SelectCommand Property

Switch on low bandwidth view

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2005/.NET Framework 2.0

Other versions are also available for the following:

.NET Framework Class Library

OracleDataAdapter.SelectCommand Property

Gets or sets an SQL statement or stored procedure used to select records in the database.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in system.data.oracleclient.dll)

Syntax

Visual Basic (Declaration)

Public Property SelectCommand As OracleCommand

Visual Basic (Usage)

Dim instance As OracleDataAdapter
Dim value As OracleCommand

value = instance.SelectCommand

instance.SelectCommand = value

public OracleCommand SelectCommand { get; set;

C++

public:
property OracleCommand^ SelectCommand {
    OracleCommand^ get ();
    void set (OracleCommand^ value);

/** @property */
public OracleCommand get_SelectCommand ()

/** @property */
public void set_SelectCommand (OracleCommand value)

JScript

public function get SelectCommand () : OracleCommand

public function set SelectCommand (value : OracleCommand)

Property Value

An OracleCommand that is used during a fill operation to select records from database for placement in the DataSet.

Remarks

When SelectCommand is assigned to a previously created OracleCommand, the OracleCommand is not cloned. Instead, the SelectCommand maintains a reference to the previously created OracleCommand object.

If SelectCommand does not return any rows, no tables are added to the DataSet, and no exception is raised.

Example

The following example creates an OracleDataAdapter and sets the SelectCommand and InsertCommand properties. It assumes you have already created an OracleConnection object.

[Visual Basic]

Public Shared Function CreateCustomerAdapter(conn As OracleConnection) As OracleDataAdapter 
  
  Dim da As OracleDataAdapter = New OracleDataAdapter()
  Dim cmd As OracleCommand

  ' Create the SelectCommand.

  cmd = New OracleCommand("SELECT * FROM Dept " & _
                       "WHERE DName = :pDName AND Loc = :pLoc", conn)

  cmd.Parameters.Add("pDName", OracleType.NVarChar, 14)
  cmd.Parameters.Add("pLoc", OracleType.NVarChar, 13)

  da.SelectCommand = cmd

  ' Create the InsertCommand.

  cmd = New OracleCommand("INSERT INTO Dept (DeptNo, DName) " & _
                       "VALUES (pDeptNo, pDName)", conn)

  cmd.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo")
  cmd.Parameters.Add("pDName", OracleType.NVarChar, 14, "DName")

  da.InsertCommand = cmd

  Return da
End Function

[C#]

public static OracleDataAdapter CreateCustomerAdapter(OracleConnection conn)
{
  OracleDataAdapter da = new OracleDataAdapter();
  OracleCommand cmd;

  // Create the SelectCommand.

  cmd = new OracleCommand("SELECT * FROM Dept " +
                       "WHERE DName = :pDName AND Loc = :pLoc", conn);

  cmd.Parameters.Add("pDName", OracleType.NVarChar, 14);
  cmd.Parameters.Add("pLoc", OracleType.NVarChar, 13);

  da.SelectCommand = cmd;

  // Create the InsertCommand.

  cmd = new OracleCommand("INSERT INTO Dept (DeptNo, DName) " +
                       "VALUES (:pDeptNo, :pDName)", conn);

  cmd.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");
  cmd.Parameters.Add("pDName", OracleType.NVarChar, 14, "DName");

  da.InsertCommand = cmd;

  return da;

Platforms

Windows 98, Windows 2000 SP4, Windows Millennium Edition, 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.

Version Information

.NET Framework

Supported in: 2.0, 1.1

Reference

OracleDataAdapter Class
OracleDataAdapter Members
System.Data.OracleClient Namespace
OracleDataAdapter.DeleteCommand Property
OracleDataAdapter.InsertCommand Property
UpdateCommand