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

Public Sub New (
	commandText As String,
	connection As OracleConnection
)

Parameters

commandText
Type: System.String

The text of the query.

connection
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
Show: