Select next record from mysql db

[djpaul]

Hello,
I am creating a program to save repair reports from audio/video equipment.
But i created also a searchbox wich displays 1 or more records.
But how can i get the next record when i press on a button 'next' or 'previous'?

This is some of my code:

conn = New MySqlConnection
            Dim Command As New MySqlCommand
            Dim Data As MySqlDataReader
            Dim myAdapter As New MySql.Data.MySqlClient.MySqlDataAdapter
            Dim Sql As String
            Dim Rows As Integer = 0
 
conn.ConnectionString = "server=" & My.Settings.Server & ";" & "user id=" & My.Settings.Loginnaam & ";" _
                                       & "password=" & My.Settings.Passwoord & ";" & "database=" & My.Settings.Database
 
                Sql = "SELECT * FROM device, customer WHERE (Device.customerID = customer.ID) AND " & Search & " LIKE '%" & SearchText & "%'  ORDER BY device.ID;"
 
                conn.Open()
                Command.Connection = conn
                Command.CommandText = Sql
 
                Data = Command.ExecuteReader
                If Data.HasRows = False Then
                    MessageBox.Show("No records found", "Albersoft - RepairService", MessageBoxButtons.OK, MessageBoxIcon.Information)
                    Info_Load(sender, e)
                Else
                    While Data.Read()
'doing thing..
End While
 

Somebody some advice?

I mean it's a kind of pagination thing.

Gr Paul

[Plater]

The lines
While Data.Read()
'doing thing..
Each call to .Read() moves to the next record.
I would recomend creating a DataTable (Look up MySqlDataAdapte r's for an easy way to do that) and using the datatable for things.
At very least it will give you an indexable set of records so you can move forward and back.

[djpaul]

Ohkay,
So i don't have to use the function LIMIT 0, 2(of course with some variables) and so on.
I will found it out!

Thanks!
Paul