Connection Property (OracleCommand)
Gets or sets the
OracleConnection used by this instance of the
OracleCommand.
Property Value
The connection to a data source. The default value is a null reference.
The following example creates a
OracleCommand and sets some of its properties.
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;
}
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