FetchAll Property (MySqlCommand)

In This Topic

Gets or sets a value indicating whether the MySqlDataReader object will request data from the server on execution ExecuteReader method.

Syntax

Visual Basic
C#

'Declaration
 
Public Property FetchAll As Boolean

public bool FetchAll {get; set;}

Property Value

true, if the MySqlDataReader object will request data from the server on execution ExecuteReader; otherwise false. The default value is false.

Remarks

If FetchAll property set to true you can use MySqlDataReader.Seek method, MySqlDataReader.RecordCount and MySqlDataReader.CurrentRecord properties for arbitrary navigation through data. Also you can get IEnumerator interface from MySqlDataReader object several times.

Example

The following example fills a MySqlDataReader and renders data to console. This sample demonstrates ability to navigate through the MySqlDataReader (this can be done several times) when FetchAll property is set to true.

csharp

public void FetchThemAll(MySqlConnection myConnection)
{
  MySqlCommand cmd = new MySqlCommand("SELECT EmpNo, EName FROM Emp");
  cmd.FetchAll = true;
  cmd.Connection = myConnection;
  myConnection.Open();
  MySqlDataReader reader = cmd.ExecuteReader();
  foreach (IDataRecord rec in reader) 
  {
    Console.Write(rec["EmpNo"]);
    Console.WriteLine("\t"+rec["EName"]);
  }
}

Visual Basic

Public Sub FetchThemAll(ByVal myConnection As MySqlConnection)
  Dim cmd As MySqlCommand = New MySqlCommand("SELECT EmpNo, EName FROM Emp")
  cmd.FetchAll = True
  cmd.Connection = myConnection
  myConnection.Open()
  Dim reader As MySqlDataReader = cmd.ExecuteReader()
  For Each rec As IDataRecord In reader
    Console.Write(rec("EmpNo"))
    Console.WriteLine(String.Concat("  ", rec("EName")))
  Next
End Sub

Reference

MySqlCommand Class
MySqlCommand Members
MySqlDataReader Class
ExecuteReader Method

Send Feedback