Have you checked out RadGrid's client-side databinding demos?
RadGrid Client-Side Programmatic DataBinding
RadGrid Client-Side Declarative DataBinding
I believe they demonstrate exactly the scenario you need. Just a note on using Location
in RadGrid. This setup tells RadGrid that it is supposed to databind to a web service automatically. This is why you cannot cancel the command event. RadGrid still makes a service call. Depending on your scenarios, you have two advisable approaches here:
1. When using automatic data source binding (keeping Location and SelectMethod) RadGrid has already built the sort and filter expressions. You can modify them right in the OnCommand event handler and RadGrid will send them as you need to the web service.
2. When using programmatic web service binding, remove the Location and SelectMethod properties, cancel the OnCommand event and make a service request programmatically (e.g. thorugh jQuery.ajax). The filter and sort expressions will be available again for you in the OnCommand event handler, so you can access them, apply any modifications needed and append them to the service call.
These 2 approaches are, in fact, what the above linked RadGrid demos show. Hope it helps.
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed