4 Answers, 1 is accepted
Let's say, you have RadGrid1 on your page. You handle NeedDataSource event to provide some datasource to your grid. To minimize selected data you have to pass correct SQL-request. For example, if the user selected "MyValue" as a filter value for SomeColumn and EqualsTo as a filter function, you should send "SELECT * FROM SomeTable WHERE SomeColumn = ''"
Of course, it is very simple code, just to give you an idea how to implement desired functionality.
But is there a way to use the filters built intothe grid and get the filter desired by the client during the NeedDataSource? Example workflow:
* Send some amount of data to the grid
* Client changes filter for some column = value
* NeedDataSource is called and query is changed accordingly
Of course, you have to use your own values for CurrentFilterValue and CurrentFilterFunction. And even your own approach to define your filter by default.