Load filter from database in SQL format

2 posts, 0 answers
  1. Sergio
    Sergio avatar
    1 posts
    Member since:
    Mar 2009

    Posted 21 May 2012 Link to this post

    Hello,

    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
    Admin
    Vasil avatar
    1547 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
    http://demos.telerik.com/aspnet-ajax/filter/examples/customeditors/defaultcs.aspx

    Greetings,
    Vasil
    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. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top