Use Filter and Sort Server Side

[Rolland]

Hello, 

 

I am currently Databinding elements from server side database(DB) to my grid and would like the Filter and Sort to be managed Server side too (Client side is too slow).

Is there any options available for this ? 

 

If no, is there a way to use the filter and sort from Grid to launch my own code using the values to do my own server-side query to my DB and refresh the data ? 

Thanks for the help.

[Eyup]

Hi Rolland,

You can achieve initial sorting using the following configuration:

<MasterTableView ...>
    <SortExpressions>
        <telerik:GridSortExpression FieldName="ShipName" SortOrder="Descending" />
    </SortExpressions>

As for applying default filter programmatically, please use the FireCommandEvent method as suggested in the following post:
http://www.telerik.com/forums/radgrid-enable-filter-code-behind#cel1slcp-U-pmV28CfXTrg

I hope this will prove helpful.

Regards,
Eyup
Telerik by Progress