dotConnect for MySQL Documentation
Devart.Common Namespace / DbScript Class / ExecuteNext(IDataReader) Method
DbDataReaderBase to store result set.
Example

On this page
    ExecuteNext(IDataReader) Method
    On this page
    Executes the next statement from the script.
    Syntax
    '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.
    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