Paging through lots of data efficiently (and in an Ajax way) with ASP.NET 2.0

Paging through lots of data efficiently (and in an Ajax way) with ASP.NET 2.0

"David Hayden blogged about a cool new ROW_NUMBER() function that SQL 2005 provides that got me excited and inspired to write a little code last night.

You can download the sample app I built here.

Features of the Sample
This sample is a self-contained ASP.NET application that demonstrates a few things:

- How to implement a data-result search page built with ASP.NET 2.0 and Atlas that can present hundreds of thousands of row results using the ASP.NET 2.0 GridView control..

- How to optimize the number of rows returned by the SQL Server to the middle-tier web-server...

- How to easily implement Ajax UI support for paging/editing/deleting on top of hundreds of thousands of rows of data (so no full page refreshes – instead it only updates the portion of the page that changes)...

- How to easily implement Ajax UI support for adding “auto-suggest” behavior to controls like text-boxes...

- How to implement a business class façade/wrapper around a data access layer...

..."

Scott has posted a very cool and complete SQL2005/ASP.Net/Ajax Paging example.

I'm thinking about using something like this in a WinForm project. Think about having users that expect to be able to view a grid of tens of thousands of rows, but also expect said grid to fill in seconds...

ROW_NUMBER sounds like a good fit to help provide this functionality. That with a grid with virtual cabilities, the BackgroundWorker and some math and I should be gold ("Right...")

Update #1 1/3/2005 @ 8:44 AM (PST):
This is a "clean up" update. I'm starting to post with IMHO and am learning how to best use it with Blogger.

Lesson #1: Either turn off Blogger's CRLF = Newline/Break feature or turn on IMHO's Strip CRLF on Post feature (that's what I did)....