OracleCommand Constructor(String,OracleConnection)
Initializes a new instance of the
OracleCommand class with the text of the query and a
OracleConnection object.
The following example creates a
OracleCommand and sets some of its properties.
|
|---|
public void CreateCommand()
{
OracleConnection oracleConnection = new OracleConnection(
"User Id=Scott;Password=tiger;Data Source=Ora;");
string mySelectQuery = "SELECT * FROM Test.Dept";
OracleCommand oracleCommand = new OracleCommand(mySelectQuery, oracleConnection);
oracleCommand.FetchSize = 100;
} |
|
|---|
Public Sub CreateCommand()
Dim oracleConnection As New OracleConnection( _
"User Id=Scott;Password=tiger;Data Source=Ora;")
Dim mySelectQuery As String = _
"SELECT * FROM Test.Dept"
Dim oracleCommand As New OracleCommand(mySelectQuery, oracleConnection)
oracleCommand.FetchSize = 100
End Sub |