Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

High Performance DataBinding for ASP.NET - A True Story

/dev/null [tony lombardo] — Wed, 12 Sep 2007 16:51:56 GMT

Performance Through Custom Paging These days, just about every ASP.NET application has a grid of some

High Performance DataBinding for ASP.NET - A True Story

Tony Lombardo — Wed, 12 Sep 2007 16:51:01 GMT

Performance Through Custom Paging These days, just about every ASP.NET application has a grid of some

re: Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

Matt — Tue, 09 Jan 2007 15:35:25 GMT

liggett78, thanks for the link to that excellent article! I'm finally able to efficiently sort my cutom-paged million-record table with SQL Server 2000. I decided to abandon the Rowcount method in favor of the slightly slower Cursor method mentioned in that article, which allows sorting on columns that aren't unique.

Another Approach to Custom Paging: C# and SQL 2005 using Optional Parameters and ROW_NUMBER()

.net_2.0 — Wed, 20 Sep 2006 21:06:52 GMT

There are alot of features with .Net 2.0 that allow for binding to data sources, and not writinga single...

re: Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

bluedee — Tue, 01 Aug 2006 09:48:12 GMT

how to implement it using sql server 2000? thanks

re: Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

FAHAD — Mon, 29 May 2006 17:07:55 GMT

I am Still confuze....

i want simple DataList Sorting and paging with AJAX and DATASET.. NOT ObjectDataSource / DAL

Plzz Reply

Regards

fahadtheking@gmail.com

Using LINQ with ASP.NET (Part 1)

ScottGu's Blog — Mon, 22 May 2006 07:22:07 GMT

One of the new things I’m super excited about right now is the LINQ family of technologies that are starting...

re: Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

liggett78 — Fri, 24 Mar 2006 12:38:00 GMT

Look at http://www.codeproject.com/aspnet/PagingLarge.asp. I implemented some of these, works great even with million rows

re: Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

Steve — Thu, 23 Mar 2006 08:08:00 GMT

Thanks! I wish I could use these techniques but our customers probably won't have 2005 for a few more years. Does anyone have a pointer to a best practices for SQL 2000?

Basically, wondering if "TOP(PageSize) ASC of TOP(PageNum*PageSize) DESC" is the best way to do things. Also, I'm curious why they can't just provide a row range operation. Seems we'll never be able to avoid having to write one sproc per orderby.... :(

re: Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

Manuel Abadia — Thu, 23 Mar 2006 07:19:00 GMT

Good catchs but as most of the examples out there he's using a DataSet instead of custom objects.

I posted about ObjectDataSource with custom paging and sorting here:

http://www.manuelabadia.com/blog/PermaLink,guid,f002752d-1258-475d-9ec0-eee3bd98d0a4.aspx

And continued here:

http://www.manuelabadia.com/blog/PermaLink,guid,eaa3eed8-f997-43c4-8c30-78c2f72d0c86.aspx

I hope the bug I pointed in the last part will be fixed soon.

Manu.