<div>
As you are doing paging now at database level. So you have to write your own pager control. <br />
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. <br />
Databind will remain as it only paging functionality u have to change.
</div>


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.

<div>
What about the datapager control?
</div>


<div>
existing pager control is the good one.
</div>


<div>
<div class="content wysiwyg-content">
I have created a sql server 2008 stored procedure tthat supports SQL Server side paging.<br />
<br />
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.<br />
<br />
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
</div>
</div>


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

server side paging and datapager

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

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,