Moving Through Dataset!!!

[barski]

How do you move through a recordset? I don't see a movenext, moveprevious etc.... Nor do I see a way to return the rowindex of my current location. So I'm at a complete loss

[Robby]

here's one way to step through the Dataset and find or change something...

 

Dim SelRow As Integer
For SelRow = DataSet1.Tables(0).Rows.Count() - 1 To 0 Step -1
   'do stuff here
Next

[Nerseus]

Robby's code shows how to loop through the Rows collection. If you're binding and need a MoveNext, MovePrevious, you'll have to look at the Form's BindingContext property. It's an array that exposes a Position property - the help files have a lot of good info and samples on how to implement the usual next/prev binding code.

 

-Nerseus