CurrentResult Property

In This Topic

Gets or sets the number of the current result in data reader.

Syntax

Visual Basic
C#

'Declaration
 
Public Property CurrentResult As Integer

public int CurrentResult {get; set;}

Property Value

The number of the current result in data reader.

Remarks

On setting CurrentResult advances the MySqlDataReader to the result with the specified number, when reading the results of batch statements.

The CurrentResult operation can be applicable only for the MySqlDataReader retrieved when FetchAll property set to true.

Example

This sample shows how to iterate through results returned by a multiple query.

csharp

public void FetchResults(MySqlConnection myConnection)
{
  MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.Dept;SELECT * FROM Test.Emp");
  cmd.FetchAll = true;
  cmd.Connection = myConnection;
  myConnection.Open();
  try
  {
    MySqlDataReader reader = cmd.ExecuteReader();
    for (int cRes = 0; cRes < reader.ResultCount; cRes++)
    {
      reader.CurrentResult = cRes;
      while (reader.Read())
      {
        for (int i = 0; i < reader.FieldCount; i++)
        {
          Console.Write("\t" + reader[i]);
        }
        Console.WriteLine();
      }
    }
  }
  finally
  {
    myConnection.Close();
  }
}

Visual Basic

Public Sub FetchResults(ByVal myConnection As MySqlConnection)
  Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept;SELECT * FROM Test.Emp")
  cmd.FetchAll = True
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As MySqlDataReader = cmd.ExecuteReader()
    Dim cRes As Integer
    For cRes = 0 To reader.ResultCount - 1
      reader.CurrentResult = cRes
      While reader.Read()
        Dim i As Integer
        For i = 0 To reader.FieldCount - 1
          Console.Write(String.Concat(" ", reader(i)))
        Next i
        Console.WriteLine()
      End While
    Next cRes
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

MySqlDataReader Class
MySqlDataReader Members

Send Feedback