I have created a sql server 2008 stored procedure tthat supports SQL Server side paging.
I use ADO.net to connect to the sql , execute the stored procedure and bind the results to a listview to display product results from a search.
If I use datapager, it seems like I need to significantly change the way I bind data. Is it easier to do paging using datapager or create my own pager control? I need the pager to be displayed on the top and bottom. Thanks