ExecuteNext(IDataReader) Method
On this page
Executes the next statement from the script.
Syntax
Parameters
- reader
- DbDataReaderBase to store result set.
Return Value
true if there are more statements to execute; otherwise, false.
Example
This sample demonstrates how to execute script and retrieve information about how many records were affected by a statement. For statements that return a result set the first column is written to console.
|
|---|
string script =
"DROP TABLE DEPT;"+
"CREATE TABLE DEPT ("+
" DEPTNO NUMBER(38) NOT NULL,"+
" DNAME VARCHAR2(14),"+
" LOC VARCHAR2(13)"+
");"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
OracleConnection oracleConn = new OracleConnection(
"User Id=Scott;Password=tiger;Data Source=Ora;");
OracleScript oracleScript = new OracleScript(script,oracleConn);
IDataReader oracleReader;
oracleConn.Open();
while (oracleScript.ExecuteNext(out oracleReader))
{
Console.WriteLine("Records affected " + oracleReader.RecordsAffected);
while (oracleReader.Read())
{
Console.WriteLine(oracleReader.GetString(0));
}
oracleReader.Close();
}
oracleConn.Close(); |
|
|---|
Dim script As String = _
"DROP TABLE DEPT;" & _
"CREATE TABLE DEPT (" & _
" DEPTNO NUMBER(38) NOT NULL," & _
" DNAME VARCHAR2(14)," & _
" LOC VARCHAR2(13)" & _
");" & _
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');" & _
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');" & _
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');" & _
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');" & _
"SELECT * FROM DEPT"
Dim oracleConn As OracleConnection = New OracleConnection( _
"User Id=Scott;Password=tiger;Data Source=Ora;")
Dim oracleScript As OracleScript = New OracleScript(script, oracleConn)
Dim oracleReader As IDataReader
oracleConn.Open()
While (oracleScript.ExecuteNext(oracleReader))
Console.WriteLine("Records affected " & oracleReader.RecordsAffected)
While oracleReader.Read()
Console.WriteLine(oracleReader.GetString(0))
End While
oracleReader.Close()
End While
oracleConn.Close() |
See Also