|
|
QueryPanel and QueryColumnsPanel controls on ASP.NET web form.
You can see the query columns and query conditions defined in these controls, SQL generated by defined query and result of SQL execution.
Additionally this form contains query representation in human-readable form (new in version 1.6.1). |
| |
|
|
|
|
Query form with query panel and result columns panel in .NET Windows Forms application.
Other useful control available in Easy Query is "result columns panel". It allows to specify the columns that will be shown in result and their sorting order. |
| |
|
|
|
 |
A query defined in query panel control and result SQL statement in Win32 application.
Query contains two levels (two conditions in the middle are in the second level). 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 result query statement). The field in the third condition is calculated (it is actually defined as MONTH(Orders.SaleDate)).
As we 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 developer. End-user does not take care about the tables their links. He(she) does not even know about such things. |
| |
|
|
|
|
Using query panel for quick filtration of the data.
This screenshot demostrates how Easy Query can be used for on-the-fly filter statements generation. User selects a table or view from database and add one or more conditions into the query panel. While conditions are entered the filter expression and the result record set are changed accordingly. |
| |
|
|
Home/Products