To do this I have to use SQL and that's all working, including paging and sorting by different columns. I take the parameters passed by the grid to the GridDataPage for sortCol, sortDir, recordsPerPage, filterValue etc and pass them to my SQL.

The XML I return is therefore already just the page needed. Can I tell the grid the actual total number of records so the paging works even though I'm not passing all the xml? I've set the

Instance.AllRecords = false;
Instance.MoreRecords = pageSize * pagenumber < totalrecords;

but the grid still doesn't even show a next page, never mind the correct total as there's no total count field so is the paging in my SQL pointless?