The idea is, You need to override the adapter's fill method. Here is the the method info

adapter.Fill(Dataset, StartRecord, NumberofRecords, TableName)

Let me add the sample program here. This will navigate the records as you needed. But you need to add the validations such as last record, first record ... so on and try-catch exception handling and also may need some tweaks in increment/decrement navigation.