dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDataReader Class / Seek Method
The zero-based position of the record that will be read next from the current result in data reader.
Example

In This Topic
    Seek Method (MySqlDataReader)
    In This Topic
    Sets the position within the current result to the specified value.
    Syntax
    'Declaration
     
    Public Sub Seek( _
       ByVal position As Integer _
    ) 
    public void Seek( 
       int position
    )

    Parameters

    position
    The zero-based position of the record that will be read next from the current result in data reader.
    Remarks
    The Seek operation can be applicable only for the MySqlDataReader retrieved when FetchAll property set to true.
    Example
    This sample shows how to retrieve only the last 2 records from a table.
    static void FetchLastRecords(MySqlConnection myConnection)
    {
      MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.Dept");
      cmd.FetchAll = true;
      cmd.Connection = myConnection;
      myConnection.Open();
      try
      {
        MySqlDataReader reader = cmd.ExecuteReader();
        reader.Seek(reader.RecordCount-2);
        while (reader.Read())
        {
          for (int i=0;i < reader.FieldCount;i++)
          {
            Console.Write("\t"+reader[i]);
          }
          Console.WriteLine();
        }
      }
      finally
      {
        myConnection.Close();
      }
    }
    Public Sub FetchLastRecords(ByVal myConnection As MySqlConnection)
      Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept")
      cmd.Connection = myConnection
      cmd.FetchAll = True
      myConnection.Open()
      Try
        Dim reader As MySqlDataReader = cmd.ExecuteReader()
        reader.Seek(reader.RecordCount - 2)
        While reader.Read()
          Dim i As Integer
          For i = 0 To reader.FieldCount - 1
            Console.Write(" " & reader(i))
          Next i
          Console.WriteLine()
        End While
        reader.Close()
      Finally
        myConnection.Close()
      End Try
    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