«

I would like to retrieve 5 records (of products) at a
time from an SQL Server database and display them in an
ASPataList control (or possibly an ASP:Repeater
control). I only want to display 5 records at a time on
each web page. The user will be able to see more products
by navigating to the next 5 items etc in a similar way to
how users navigate on search engine results. The user
will also be able to select which order the items will be
displayed in according to different criteria (model
number, price etc.).

My main problem is, what is the most efficient way to
obtain records n to n+5 and bind them to a datalist
control? Ideally I would like to write a stored procedure
to extract just those records and then I will attach them
to a DataReader object which I could then bind to the
DataList control. But how can I obtain just those 5
records?

TIA
Elliot Cohen
Messorah Software