Navigate Through Table !!

I have connected to the access database that is ok and also i am getting the value of the first field.
Now I want to navigate through the records moveFirst,MoveLast,MovePrevious and Movenext in VB.Net

code in vb.net
<!--
adAdapter = New OleDbDataAdapter(strSQL, cnConnection)
adAdapter.Fill(dataset1,"AUTHOR")
console.writeline dataset1.Tables(0).Rows(0).Item(0)
-->

Need guidance ... help !!!

This was in ADO (VB6) days , sadly it's been removed from ADO.NET . I'll try to do a sample though .

I've just built a simple demo that shows you how this can be done in ADO.NET .
Enjoy !

Note !
I used XP ACCESS DB .You have no problems if you have access 2000 db.

Cursors are not managed by datatables in .NET, rather by a mysterious fella' named the CurrencyManager. You increment/decrement the position property to navigate through the cursor. The CurrencyManager also handles the addition/deletion of records.

Code:

---

  this.BindingContext[ds, "Customers"].Position++;

---

This code snippet is in C#, but I bet you get the picture...;)

Hmm , this sounds easier . Is it available for bindings only ?:rolleyes:

For each distinct datasource on a form, there is an associated CurrencyManager. His job is to police the currency/updating of all controls that are bound to the particular datasource.