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