Moving Through Dataset!!!

[barski]

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

 

[Robby]

heres 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]

Robbys code shows how to loop through the Rows collection. If youre binding and need a MoveNext, MovePrevious, youll have to look at the Forms BindingContext property. Its 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