Avatar of TrialUser
TrialUserFlag for Afghanistan

asked on 

server side paging and datapager

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
ASP.NETC#Visual Basic.NET

Avatar of undefined
Last Comment
TrialUser
Avatar of anillucky31
anillucky31
Flag of India image

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.
Avatar of TrialUser
TrialUser
Flag of Afghanistan image

ASKER

What about the datapager control?
ASKER CERTIFIED SOLUTION
Avatar of anillucky31
anillucky31
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

existing pager control is the good one.
Avatar of TrialUser
TrialUser
Flag of Afghanistan image

ASKER

thx a ton
ASP.NET
ASP.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo