RecordCount Property (MySqlDataReader)
In This Topic
Gets the number of rows retrieved from the server for the current result in data reader.
Syntax
|
|---|
'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.
Example
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 |
See Also
