Filter Grid Using ComboBox and Stored Procedure

[Richard Weeks]

I've got a filtered column with a ComboBox displaying values ok, according to the example at:

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filtertemplate/defaultcs.aspx

But I'm stuck converting the filter operation to use a stored procedure instead of appending a WHERE onto a select.

The ComboBox in my RadGrid column is fed by this:

<asp:SqlDataSource
    ID="CategoriesDataSource"
    runat="server"
    ConnectionString="<%$ ConnectionStrings:Development %>"
    SelectCommand="myApp_CategoriesSelect"
    SelectCommandType="StoredProcedure">
</asp:SqlDataSource>

What do I need to do to get this adapted? I think it has to do with adding the parameters but I'm unsure how to go about hacking up the example above to that end.

Regards,
Richard

[Schlurk]

From what I can tell all you would have to do is actually call your stored procedure to get the data, and then set this as the datasource of the MasterTableView and rebind it - that's essentially what the demo is doing with these select statements with "where" clauses, and it seems like that is the best way to approach this.