Which control should I use to present records from a set one after another without reissueing the query

Question

I have a bank of 100 questions in a database. I T-SQL has been written by someone else to pick 30 unique questions out of the 100 in a random fashion. (the query was tested and result were as expected)

Now, I need those 30 unique records (the random sample) to be displayed one at a time. basically showing the next record when the user clicks a button (next for instance).

Currently, I have a sqlDataSource with its ID assigned to a DetailsView in aspx page. I have a button that basically increments the DetailsView.PageIndex.

I found that the detailsView keeps reexecuting the sqlCommand in the sqlDataSource resulting in repeated questions. I found out by tracing the sql.

What am I doing wrong or Which data control to use and any other suggestions and if possible refer me to an example please?

Thank you so much!

Answer 1

I would suggest trying the GridView Control. You can use the controls paging ability to decide how much of your record set to display (without having to re-execute the sqlCommand).

Here are some good examples of how to use the GridView control.