Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Filter > Load filter from database in SQL format

• Sergio

  Posted on May 21, 2012 (permalink)

  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? :)

  Reply

• Vasil Vasil

  Posted on May 24, 2012 (permalink)

  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.

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Filter > Load filter from database in SQL format