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