OracleCommand Constructor(String,OracleConnection,OracleTransaction)
Initializes a new instance of the
OracleCommand class with the text of the query, a
OracleConnection object, and the
OracleTransaction.
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;");
oracleConnection.Open();
OracleTransaction myTrans = oracleConnection.BeginTransaction();
string mySelectQuery = "SELECT * FROM Test.Dept";
OracleCommand oracleCommand = new OracleCommand(mySelectQuery, oracleConnection,myTrans);
oracleCommand.FetchSize = 100
} |
|
|---|
Public Sub CreateCommand()
Dim oracleConnection As New OracleConnection( _
"User Id=Scott;Password=tiger;Data Source=Ora;")
oracleConnection.Open()
Dim myTrans As OracleTransaction = oracleConnection.BeginTransaction()
Dim mySelectQuery As String = _
"SELECT * FROM Test.Dept"
Dim oracleCommand As New OracleCommand(mySelectQuery, oracleConnection, myTrans)
oracleCommand.FetchSize = 100
End Sub |