OracleCommand Constructor (String, OracleConnection)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

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 System.Data.OracleClient.dll)

Public Sub New (
	commandText As String,
	connection As OracleConnection


Type: System.String

The text of the query.

Type: System.Data.OracleClient.OracleConnection

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

.NET Framework
Available since 1.1
Return to top