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

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

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
See Also