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 IF EXISTS DEPT;"+
"CREATE TABLE DEPT ("+
" DEPTNO INT PRIMARY KEY,"+
" DNAME VARCHAR(14),"+
" LOC VARCHAR(13)"+
") TYPE = InnoDB;"+
"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";
MySqlConnection mySqlConn = new MySqlConnection(
"User Id=root;Host=localhost;Database=Test;");
MySqlScript mySqlScript = new MySqlScript(script,mySqlConn);
IDataReader mySqlReader;
mySqlConn.Open();
while (mySqlScript.ExecuteNext(out mySqlReader))
{
Console.WriteLine("Records affected " + mySqlReader.RecordsAffected);
while (mySqlReader.Read())
{
Console.WriteLine(mySqlReader.GetString(0));
}
mySqlReader.Close();
}
mySqlConn.Close(); |
|
|---|
Dim script As String = _
"DROP TABLE IF EXISTS DEPT;" & _
"CREATE TABLE DEPT (" & _
" DEPTNO INT PRIMARY KEY," & _
" DNAME VARCHAR(14)," & _
" LOC VARCHAR(13)" & _
") TYPE = InnoDB;" & _
"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 mySqlConn As MySqlConnection = New MySqlConnection( _
"User Id=root;Host=localhost;Database=Test;")
Dim mySqlScript As MySqlScript = New MySqlScript(script, mySqlConn)
Dim mySqlReader As IDataReader
mySqlConn.Open()
While (mySqlScript.ExecuteNext(mySqlReader))
Console.WriteLine("Records affected " & mySqlReader.RecordsAffected)
While mySqlReader.Read()
Console.WriteLine(mySqlReader.GetString(0))
End While
mySqlReader.Close()
End While
mySqlConn.Close() |
See Also