ResultCount Property

In This Topic

Gets the number of results in data reader.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property ResultCount As Integer

public int ResultCount {get;}

Property Value

The number of results in data reader.

Remarks

The ResultCount 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