ExecuteNext(IDataReader) Method
Executes the next statement from the script.
Parameters
- reader
- DbDataReaderBase to store result set.
Return Value
true if there are more statements to execute; otherwise, false.
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 =
"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();
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()
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2