Hi,
I am currently in the process of upgrading my current website from 1.1 to 2.0.
I use the old data grid to display 10 records per page and I have used a complex stored procedure to get the correct 10 records. I also use coded navigation for next, last page etc.
My Question is that I feel that everyone is saying that 2.0 has reduced a lot of coding that was required in 1.1 with the new controls like the ‘Grid view’. So do I still carry on using the Stored procedure or let the built in features of the ‘Grid View’ to handle paging and even when the database has thousands of records the page will only get 10 records at a time efficiently.


rbagdai

I don't think you will have much of a problem. As an example, a colleague of mine was working on an Address book type application for a client and the table in our database that was related to this portion of the application had 60K rows of data.

Originally he Databound the entire 60K rows of data to the gridview with paging set at 20 records per page and the control was extremely responsive so I think that you will be ok but test it out and see how the control preforms for you.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

A lot of this will be dictated by the testing you do for your application. And if you build something from scratch, then personal preference will have a lot to do with it. I know a number of guys who breathe the name SqlDataSource with the same venom they reserve for PHP; they build all their own custom objects and their applications are very finely tuned. However, when you're getting started (especially if you're new to OOP) using the predefined objects in the .NET framework allows you to leverage a lot of power without having to understand and code where it all comes from. The Providers really stand out here. I've never met anyone who's built a role based system to compare with the Roles Provider, or a login with all the security features that come prepackaged with the drag and drop login family of controls. So there's not only a lot of objects to get you started in 2.0 even for beginners, but there's certain areas where 2.0 has added a tremendous amount of power that you can use without coding it yourself (because you wouldn't be able to if you tried).

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.