Load filter from database in SQL format

3 posts, 0 answers
  1. Sérgio
    Sérgio avatar
    2 posts
    Member since:
    Mar 2009

    Posted 21 May 2012 Link to this post


    I'm trying to build an application which allows the user to create filters and save them in a database to be used with SSIS.
    I'm able to save and load the filter in base64 format and i can also get the generated SQL with the RadFilterSqlQueryProvider.

    I have to make the initial parametrization of the application, and it has lots and lots of filters and criteria and I would like to use something like a spreadsheet to build the string, something like ([Field1] = '7' AND [Field2] = 8), save it directly to the database (MS SQL Server 2008) and have RadFilter parse those strings.
    Then the user would be able to edit the filters and I wouldn't have to build them "manually" via webform. :)

    I'm using VS2010 with ASP.Net Ajax Q1 2012 SP1

    Can anyone show me the light? :)
  2. Vasil
    Vasil avatar
    1640 posts

    Posted 24 May 2012 Link to this post

    Hello sergio,

    If you use the RadFilter to filter your values you could store the encoded settings in your database and use the SaveSettings and LoadSettings methods of the RadFilter.
    For the initial creation of the filters, you will need to parse the spreadsheet like file yourself and to add the expressions manually on the Page_Load event similar to this online demo

    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 now.
  3. Sérgio
    Sérgio avatar
    2 posts
    Member since:
    Mar 2009

    Posted 21 Jul 2017 in reply to Sérgio Link to this post

Back to Top