Wednesday, 15. December 2010
ASP.Net DataPager Efficient w/ ObjectDataSource12/15/2010
If you use a DataPager w/ a regular DataSource control so that you can page .Net 4.0's ListView, you'll find that it loads the entire dataset each time it pages. However, if you create a data access class that you can connect to an ObjectDataSource control that you then connect the DataPager to, the DataPager will use the ObjectDataSource's startindex/maxrows to read the data somewhat efficiently. Setting it up is a bit convoluted, but it's covered in this blog post relatively well: http://samsalisbury.net/articles/objectdatasource-listview-paging-minimal-example/
However, there is still a weakness in the ObjectDataSource. When your data layer is called, there is no access to the web page fields, so you have to use the ObjectDataSource's Selecting event to load them and this can get tedious if you have a lot of fields. The ObjectDataSource also seems to call your TotalRowCount function every time it pages instead of storing that value in viewstate or a cookie.
Ken's Blog
-