This documentation is archived and is not being maintained.

OracleCommand.OracleCommand(String, OracleConnection) Constructor

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
Not applicable.



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 Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1