RecordCount Property (MySqlDataReader)

In This Topic

Gets the number of rows retrieved from the server for the current result in data reader.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property RecordCount As Integer

public int RecordCount {get;}

Property Value

The number of rows retrieved from the server for the current result in data reader.

Remarks

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

Example

This sample demonstrates usage of RecordCount property.

csharp

public void HowManyRows(MySqlConnection myConnection)
{
  MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.Dept");
  cmd.FetchAll = true;
  cmd.Connection = myConnection;
  myConnection.Open();
  try
  {
    MySqlDataReader reader = cmd.ExecuteReader();
    Console.WriteLine("Number of rows in the table: " + reader.RecordCount);
    reader.Close();
  }
  finally
  {
    myConnection.Close();
  }
}

Visual Basic

Public Sub HowManyRows(ByVal myConnection As MySqlConnection)
  Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept")
  cmd.FetchAll = True
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As MySqlDataReader = cmd.ExecuteReader()
    Console.WriteLine("Number of rows in the table: " & reader.RecordCount)
    reader.Close()
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

MySqlDataReader Class
MySqlDataReader Members
CurrentRecord Property
FetchAll Property
HasRows Property

Send Feedback