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.
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!