This documentation is archived and is not being maintained.

OracleCommand Constructor (String, OracleConnection)

Initializes a new instance of the OracleCommand class with the text of the query and an OracleConnection object.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in

Public Sub New ( _
	commandText As String, _
	connection As OracleConnection _
Dim commandText As String
Dim connection As OracleConnection

Dim instance As New OracleCommand(commandText, connection)
public OracleCommand (
	String commandText, 
	OracleConnection connection
public function OracleCommand (
	commandText : String, 
	connection : OracleConnection



The text of the query.


An OracleConnection object that represents the connection to a database.

The following example creates an OracleCommand.

Public Sub CreateOracleCommand()
    Dim connection As New OracleConnection _
       ("Data Source=Oracle8i;Integrated Security=yes")
    Dim queryString As String = _
       "SELECT * FROM Emp ORDER BY EmpNo"
    Dim command As New OracleCommand(queryString, connection)
End Sub

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1