Seek Method (MySqlDataReader)
Sets the position within the current result to the specified value.
'Declaration
Public Sub Seek( _
ByVal As Integer _
)
Parameters
- position
- The zero-based position of the record that will be read next from the current result in data reader.
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