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

Reference

OracleCommand Class
OracleCommand Members
CommandText Property
CommandType Property

Send Feedback