server side paging and datapager

TrialUser
TrialUser used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
As you are doing paging now at database level. So you have to write your own pager control.
You need to change lot of thing now. you have to make you customize function to handle paging now in .net and has to calculate startindex and endindex of page by yourself.
Databind will remain as it only paging functionality u have to change.

Author

Commented:
What about the datapager control?
see this article how you can use datapager control with custom paging

http://www.codeproject.com/KB/custom-controls/ASPNETPagerControl.aspx
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)

Commented:
existing pager control is the good one.

Author

Commented:
thx a ton

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial