I retrieve all the Ids from a DB table. The 'current'
Id is used to retrieve all the columns associated with
that Id. I need to Move Next and Move Previous.
The DBEnumerator is a Forward-only tool.
A "For Each Row" solution would enclose nearly the
entire application in the loop and still would not work.
Since a "Find" is supported, maintaining a Global
index to step through the rows collection would not be
There are upwards of 14,000 rows in the table, so I am
not eager to use an array.
I must use a Web Service and ADO.NET disconnected
How does one navigate forward and backward relative to
the current row without knowing the index (or can we
learn the index? The DBEnumerator was promising, but it
is forward only.