next record?

If I give a table an itemid, how do i ask for the next record? Previous record too?
Can I do that?
ThanksAre you using a dataset? If so, you just index the Rows property of tables[0] (presuming a single table in the database).|||I thought of that, but I am not sure it will be the best for this situation. Maybe it is.
I have a photo gallery control. When a photo is clicked, a popup window is opened and takes the photoid from the querystring and displays that photo.
I would like to add a previous and next button on the popup page to scroll through the images in the gallery. The only things I am concerned about is starting at the right photo in the dataset and when i get to the last record, it should loop through to the first record if the next button is clicked.
Does this sound like something I can do with a dataset?
Thanks