Seek Method (MySqlDataReader)

In This Topic

Sets the position within the current result to the specified value.

Syntax

Visual Basic
C#

'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.

csharp

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();
  }
}

Visual Basic

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

Reference

MySqlDataReader Class
MySqlDataReader Members

Send Feedback