dotConnect for Oracle Documentation
Connection Property
See Also  Example support@devart.com
Devart.Data.Oracle Namespace > OracleCommand Class : Connection Property

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

Syntax

Visual Basic (Declaration) 
Public Shadows Property Connection As OracleConnection
C# 
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 Devart.Data.Oracle.OracleCommand.

This property supports the InterForm technology.

Example

The following example creates a Devart.Data.Oracle.OracleCommand and sets some of its properties.
C#csharpCopy Code
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;
}
C#Visual BasicCopy Code
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

Platforms:Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family, Windows 7, Windows 8, Windows 10, Windows Server 2012 family.

See Also