jhermiz

Hello World,

I needed to page data in SQL Server 2k5. The paging that is already available in a datagrid, gridview in asp.net is slow since it has to pull all the data down from the server in one go and page those results. In my example I pull down only the data the user needs.

If you need to page your SQL 2005 data in ASP.net 2.0 have a look here. Works with win form applications as well...as the code behind is simply vb.net.

http://jhermiz.googlepages.com/paginginsqlserver2k5andasp.net2.0




Re: Show and Tell Paging data in SQL Server 2k5 and ASP.net 2.0

Biche

This seem to be a great code, since i'm not working with ASP anymore it is useless for me. But I had this issue with a site where they had pictures in their database so the download time was very bad... So we had managed to create our own client side paging. I hope this could help someone someday.

By the way, I liked your little mention on your website...






Re: Show and Tell Paging data in SQL Server 2k5 and ASP.net 2.0

jhermiz

What mention






Re: Show and Tell Paging data in SQL Server 2k5 and ASP.net 2.0

Biche

jhermiz wrote:
What mention

The one in red saying that this code is provided without "warranty"






Re: Show and Tell Paging data in SQL Server 2k5 and ASP.net 2.0

jhermiz

heh, I fully meant that too :) happy coding!