THE BEST OPTION FOR END USER SQL QUERIES

SQL Designer is a 100% .Net component to easily integrate into new and existing WinForms applications. Teamed up with your favorite end user reporting tool or for any other custom SQL query requirement, SQL Designer will put the power of flexible SQL Queries in the hands of your application users where it belongs and free up valuable IT time from the task of generating queries.

For those developing WebForms applications, we currently plan to release a WebUI QueryPanel for SQL Designer in 2007.

What Does It Do?

SQL Designer uses database schema definitions that represent the data structures in your database. These schema definitions then support the creation, editing and saving of SQL Query definitions. You may create any number of schema definitions using the graphical interface tools provided with SQL Designer and persist the designs to XML definition files.  SQL Designer also provides the UI components for schema building that you can place directly into your host application or, use our fully pre-built forms based interface.

With schemas created, you simply add SQL Designer's QueryPanel UI component into your application to provide the interface for users to create and/or modify query designs (return sets, criteria, or both). Query designs are also persisted to XML that may be handled by your application and stored in your database or at your option, loaded and saved directly on the file system.

Advanced functionality includes the ability to design queries to prompt users for time or context dependent query criteria and the ability to calculate and use dynamic conditions like 'is in last financial year', or, 'in last calendar quarter'.

The download includes a fully functional sample application and database. We think you'll find it the most versatile, full featured and reliable option available to support end user SQL query generation in your applications.

Additional Resources

For additional information, checkout the links to additional resources on the left hand sidebar.

We hope you find SQL Designer a useful addition to your development tool kit. If you have any input for us regarding the product, do share it with us!