RecordCount Property (MySqlDataReader)
Gets the number of rows retrieved from the server for the current result in data reader.
public int RecordCount {get;}
'Declaration
Public ReadOnly Property RecordCount As Integer
Property Value
The number of rows retrieved from the server for the current result in data reader.
This sample demonstrates usage of
RecordCount property.
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();
}
}
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
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