Navigate Through Table !!

[PankajChandak]

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 !!!

[Pirate]

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

[Pirate]

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

[Pirate]

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

[Lethal]

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.

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

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

[Pirate]

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

[Lethal]

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.