dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDataReader Class / ResultCount Property
Example

ResultCount Property
Gets the number of results in data reader.
Syntax
'Declaration
 
Public ReadOnly Property ResultCount As Integer
 

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.
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();
  }
}
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
Requirements

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

See Also