Connection Property (OracleCommand)

In This Topic

Gets or sets the OracleConnection used by this instance of the OracleCommand.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Property Connection As OracleConnection

public new OracleConnection Connection {get; set;}

Property Value

The connection to a data source. The default value is a null reference.

Remarks

OracleConnection specified in this property will carry out all operations executed with this OracleCommand.

This property supports the InterForm technology.

Example

The following example creates a OracleCommand and sets some of its properties.

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Test.Dept ORDER BY DeptNo";
  OracleCommand myCommand = new OracleCommand(mySelectQuery);
  myCommand.Connection = new OracleConnection(
    "User Id=Scott;Password=tiger;Data Source=Ora;");
  myCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Test.Dept ORDER BY DeptNo"
  Dim myCommand As New OracleCommand(mySelectQuery)
  myCommand.Connection = New OracleConnection( _
    "User Id=Scott;Password=tiger;Data Source=Ora;")
  myCommand.CommandType = System.Data.CommandType.Text
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleCommand Class
OracleCommand Members
CommandText Property
CommandType Property

Send Feedback