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