|
|
QueryPanel and QueryColumnsPanel controls on an ASP.NET web form.
You can see the query columns and query conditions defined in these controls, the SQL generated by the defined query and the result of the SQL execution.
Additionally this form contains the query representation in human-readable form (since version 1.6.1 of EasyQuery.NET).
|
| |
|
|
|
|
Query form with query panel and result columns panel in .NET Windows Forms application.
Another useful control available in Easy Query is the "result columns panel". It allows you to specify the columns that will be shown in the result and their sorting order.
|
| |
|
|
|
 |
A query defined in query panel control and result SQL statement in Win32 application.
Query contains two levels (the two conditions in the middle are in the second level). The user is able to select a value for "Payment Method" field from the list of available values.
|
| |
|
|
| |
|
Another query in query panel and the result record set.
There are two levels as well but the first condition group is disabled (disabled conditions do not take part in the result query statement). The field in the third condition is calculated (it is actually defined as MONTH(Orders.SaleDate)).
As you can see the query panel recognizes "is in list" operator in the last condition and shows the available values list with check boxes for multiple selection.
|
| |
|
|
 |
|
Data Model Editor dialog.
Visual representation of database tables and links between them.
This dialog is used only by developers. End-users do not take care about the tables and links.
|
| |
|
|
|
|
Using query panel for quick filtration of the data.
This screenshot demonstrates how Easy Query can be used for on-the-fly filter statement generation. The user selects a table or view from the database and adds one or more conditions into the query panel. While conditions are entered the filter expression and the result record set are changed accordingly.
|
| |
|
|
: Easy Query : Screenshots
Home/Products