Can anyone reccomend a free .NET libary which allows you to expose a SQL Query builder to your users in a windows form app? I'd like my users to be able to run relatively straight forward SELECT statements, including some JOINS and other multi-table operations without getting into the real nitty-gritty of SQL.
Thanks, sweeney
Report Builder is part of SQL Server Reporting Services, and it lets you do all of that and more. You can setup non-MSSQL data sources as well. We have non-developers use it all the time for creating reports with joins, grouping and so on with no SQL code.
The license is included in SQL Server Workgroup and above. I don't know if that's "free" enough for you.
You can use CodeEngine.Framework classes to select,insert,update,delete operations
You can use Aspose.Report AdHoc.WinForms component (it is not free). It requires no SQL server running, works fine with multiply tables and also have ability to make automated table join.
Take a look at the component demo on Aspose site.
I'm Aspose team developer.