Paging data

I'm trying to make a page that will take SQL records and present them as it's done in a search results page (essentially paging data): with links to the previous and next 20 records, plus a count of how many records there are on the current page and also the ability to delete a record off the page. It's a lot of stuff I've never done before and I'm not sure where to begin. <img border="0" src="/forum/emoticons/shakehead.gif" height="15" width="15" alt="shakehead" /> Can anyone start me off in the right direction (w/o referencing datagrids)?

You can do it using SQL stored procedures with temp tables. <a href="http://www.adopenstatic.com/experiments/recordsetpaging.asp" target="_blank">HERE</a> is a short article I found that has an example of what I mean.<p><hr size="1" width="50%" align="left" />dotNetBB Forum Developer<br><b><i>Building A Better Community, One Post At A Time</i></b><br><a href="http://www.dotnetbb.com" target="_blank">www.dotnetbb.com</a></p>

Thanks for the reference point, Andrew.

Not a problem. I use something similar to that for these forums. The main difference with what I do is I insert the message id (primary key) with the order id into the Temp table, then do the full select of the data based on a join with the message id field.<p><hr size="1" width="50%" align="left" />dotNetBB Forum Developer<br><b><i>Building A Better Community, One Post At A Time</i></b><br><a href="http://www.dotnetbb.com" target="_blank">www.dotnetbb.com</a></p>