Filter Grid Using ComboBox and Stored Procedure

2 posts, 0 answers
  1. Richard Weeks
    Richard Weeks avatar
    95 posts
    Member since:
    Oct 2009

    Posted 22 Jul 2010 Link to this post

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

    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:

        ConnectionString="<%$ ConnectionStrings:Development %>" 

    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.

  2. Schlurk
    Schlurk avatar
    812 posts
    Member since:
    May 2009

    Posted 27 Jul 2010 Link to this post

    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.
Back to Top