ExecuteNext(IDataReader) Method

On this page

Executes the next statement from the script.

Syntax

Visual Basic
C#


'Declaration Public Function ExecuteNext( _ ByRef reader As IDataReader _ ) As Boolean


public bool ExecuteNext( out IDataReader reader )

Parameters

reader: DbDataReaderBase to store result set.

Return Value

true if there are more statements to execute; otherwise, false.

Remarks

Use ExecuteNext method to execute the statements from the script one by one. Text of the script should be specified by ScriptText property.

After the method has executed the Progress event fires where you can obtain statement text and process query results. If the statement has produced an error, event Error fires.

To restart execution from the beginning of the script call Reset method. When ScriptText property is modified DbScript automatically positions on the first statement.

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.

csharp


string script = "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"; DB2Connection db2Conn = new DB2Connection( "user id=db2admin;server=db2;database=SAMPLE;"); DB2Script db2Script = new DB2Script(script,db2Conn); IDataReader db2Reader; db2Conn.Open(); while (db2Script.ExecuteNext(out db2Reader)) { Console.WriteLine("Records affected " + db2Reader.RecordsAffected); while (db2Reader.Read()) { Console.WriteLine(db2Reader.GetString(0)); } db2Reader.Close(); } db2Conn.Close();

string script =

  "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";
DB2Connection db2Conn = new DB2Connection(
    "user id=db2admin;server=db2;database=SAMPLE;");
DB2Script db2Script = new DB2Script(script,db2Conn);
IDataReader db2Reader;
db2Conn.Open();
while (db2Script.ExecuteNext(out db2Reader))
{
  Console.WriteLine("Records affected " + db2Reader.RecordsAffected); 
  while (db2Reader.Read()) 
  { 
    Console.WriteLine(db2Reader.GetString(0)); 
  } 
  db2Reader.Close(); 
}
db2Conn.Close();

Visual Basic


Dim script As String = _ "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 db2Conn As DB2Connection = New DB2Connection( _ "user id=db2admin;server=db2;database=SAMPLE;") Dim db2Script As DB2Script = New DB2Script(script, db2Conn) Dim db2Reader As IDataReader db2Conn.Open() While (db2Script.ExecuteNext(db2Reader)) Console.WriteLine("Records affected " & db2Reader.RecordsAffected) While db2Reader.Read() Console.WriteLine(db2Reader.GetString(0)) End While db2Reader.Close() End While db2Conn.Close()

Dim script As String = _

  "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 db2Conn As DB2Connection = New DB2Connection( _
    "user id=db2admin;server=db2;database=SAMPLE;")
Dim db2Script As DB2Script = New DB2Script(script, db2Conn)
Dim db2Reader As IDataReader
db2Conn.Open()
While (db2Script.ExecuteNext(db2Reader))
  Console.WriteLine("Records affected " & db2Reader.RecordsAffected)
  While db2Reader.Read()
    Console.WriteLine(db2Reader.GetString(0))
  End While
  db2Reader.Close()
End While
db2Conn.Close()

Reference

DbScript Class
DbScript Members
ScriptText Property
Execute Method
Progress Event
Error Event

Send Feedback