I've just started using the Infragistics grid control for an ASP.NET app. I need to be able to support paging and I'm not entirely sure what the easiest way to handle this is, inside of the MM.NET framework when using it's databinding (the sample in the docs kind of sucks). Essentially, I just want to display 20 rows at a time.

Would I have to modify my business object which fills a dataset with this table to only provide to correct 20 rows based on the current page? If so, what mechanism have people found to be the easiest? Unfortunately, we're not on SQL 2005 (yet), so I can't take advantage of the new paging syntax. If I was doing this all manually, I'd probably just skip rendering the first x number of rows based on the current page #. But, I'm not sure what would work best when using the control with MM's databinding.

To be honest, I'm a little disappointed that the control doesn't automatically handle this (e.g. I pass it the full dataset and it tracks the current row based on the page and only renders the correct rows); if I'm missing some functionality to do this, I'd love to hear about it.

Thanks,