Just a quick tip:
I got the following exception today:
If a data source does not return ICollection and cannot return the total row count, it cannot be used by the GridView to implement server-side paging.
If you’re trying to return an IEnumerable from your select method, try changing it to a List or an array. That should clear the problem right up.