SQL query builder from an App
-
We have an app made in C# which promtes users for a sql query at run time, this has become difficult for the users but we were thinking of an easy to use query builder to integrate & instead of writing from scratch we were were wondering if there were available tools to use ??
-
We have an app made in C# which promtes users for a sql query at run time, this has become difficult for the users but we were thinking of an easy to use query builder to integrate & instead of writing from scratch we were were wondering if there were available tools to use ??
I do not know of a query-builder per se, but at one time we had to generate reports where the functionality would be similar to what you want to do. But like you said, it is difficult for users to write full blown queries, and not only that but you could also run into security problems... The solution we came up was using templates (SQL Server 2000)...where we had multiple queries defined and users would click on the the most appropriate report type, enter some parameters and bingo, get a report back. A template might look like this: 0000> Select CustomerName 'name' From dbo.Customer where gender = @fieldid for xml raw This would return the data in xml format (dat as root) - which can be routed through xslt to output nicely formatted result (text/html etc). This is just an idea - I am sure there are other options out there. This worked well for us as we had more control over every aspect and we could add more "reports" as needed by users. Let me know if you want to pursue this option and I'll point you into the right direction.
-
I do not know of a query-builder per se, but at one time we had to generate reports where the functionality would be similar to what you want to do. But like you said, it is difficult for users to write full blown queries, and not only that but you could also run into security problems... The solution we came up was using templates (SQL Server 2000)...where we had multiple queries defined and users would click on the the most appropriate report type, enter some parameters and bingo, get a report back. A template might look like this: 0000> Select CustomerName 'name' From dbo.Customer where gender = @fieldid for xml raw This would return the data in xml format (dat as root) - which can be routed through xslt to output nicely formatted result (text/html etc). This is just an idea - I am sure there are other options out there. This worked well for us as we had more control over every aspect and we could add more "reports" as needed by users. Let me know if you want to pursue this option and I'll point you into the right direction.