Seek Method (MySqlDataReader)

In This Topic

Syntax
Remarks
Example
Requirements
See Also

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

Syntax

Visual Basic
C#

public void Seek( 
   int position
)

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

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

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

Reference

MySqlDataReader Class
MySqlDataReader Members

Send Feedback