I have an asp.net application that will use a SQL Server DBMS for the
On my asp.net form. I have a next, previous, last and first buttons on my
Basically, this application will allow the user to page through some data
one record at a time.
Let's say my SQL statement returns the following rows with ID's of (1, 3,
5, 9, 10).
What would be the best way that I can always retrieve the previousID and
nextID according to the rows my Select SQL statement returned?