dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlCommand Class / FetchAll Property
Example

In This Topic
    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
    '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.
    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"]);
      }
    }
    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
    Requirements

    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

    See Also