GridView Databinding and Paging
<p>What is the best way to retrieve records from the database? 
Currently we are grabbing all of them, caching them, and binding them to our GridView control. We incorporate paging using this control.
So what would be better? Retrieving all the records like we are currently doing, or just retrieving the records needed using an index and row count.</p>
