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)....
No comments:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...