Connection Property

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

[Visual Basic]
Public Property Connection As OracleConnection

[C#]
public OracleConnection Connection {get; set;}

Return Type

The connection to a database. 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.

[C#]

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

See Also

Language

Connection Property

Return Type

Remarks

Example

See Also