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 OracleCommand (
	string commandText,
	OracleConnection 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 void CreateOracleCommand() 
   OracleConnection connection = new OracleConnection("Data Source=Oracle8i;Integrated Security=yes");
   string queryString = "SELECT * FROM Emp ORDER BY EmpNo";
   OracleCommand command = new OracleCommand(queryString, connection);

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