We are using an ObjectDataSource with the RadGrid. When I use filter and sort the full list is retrieved from the datasource and then filtered/sorted afterwards.
I would like to be able to use these in the retrieval process (and push the work back onto the SQL server). However I can't seem to find a way to get the filtercommand or sortcommand where I want it (and tell the grid that I've already done the work). With a standard DataGrid/ObjectDataSource pair I would simply add a sort parameter name and the gridview would fill it in. Does the RadGrid support anything like this?
As another option it doesn't have to be so automatic, I can provide the values to the datasource using its onselecting event. I just can't figure out where to get the values at that point. Right now I have placed them in a page level variable, which is a little ugly. I would like to be able to just access the current FilterCommand or SortCommand from the Grid. Something like: RadGrid.GetCurrentSortCommand() ?
Thanks
Matt