EasyQuery.NET (WinForms) 2.4.0

EasyQuery.NET (WinForms) 2.4.0 offers an effective tool which helps you to add one more form in your program which just show the result of some query in a data grid?

Tired to add new forms and new reports in your program?

EasyQuery.NET WinForms edition let your users to get the data they want without any assistance from developer. This outstanding solution allows to create queries to your database using friendly graphical interface which looks for end-user as just a statement in his(her) native language.

EasyQuery.NET library is a set of native .NET classes, components and controls that allows you to include end-user-oriented query builder into your .NET Windows Forms application .

Your users receive the ultimate ability to build their own queries and get all data they want without necessity to understand your database design or table relationships. They do not see the real tables and real fields names, and see only the tables names and fields descriptions, which one you want, that they should see (e.g. "Customer Address" instead of Cust.Addr in result SQL statement).

Operators can be spelled out (e.g. "is equal to" instead of mathematical symbol). Field values can be replaced with descriptions (e.g. "MasterCard" instead of actual values like "MC") that make interface more friendly.

Being used in your application EasyQuery.NET provides the power of SQL with accessibility of natural language!

Major Features:

1. Natural language user interface for query building
2. Two main editions:
3.  WinForms edition - for Windows Forms applications
4.  WebForms edition - for ASP.NET web-sites
5. Programming language: C#
6. Distributed as 100% pure .NET assemblies
7. Supported .NET framework versions: 1.1 (only WinForms editions), 2.0, 3.5
8. Supported databases: MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL as well as any other database which can be used through ADO.NET
9. ASP.NET AJAX support in WebForms edition

• Added: An ability to define sorting columns separately from the main column list;
• Added: BuildParamSQL() method in Query class which allows to build parametrized SQL statements;
• Added: Params property in Query.Result - give an access to list of parameters in case of using BuildParamSQL method;
• Added: AllowSorting property in QueryColumnsPanel control;
• Added: "Aggregate" property for virtual entity attributes;
• Added: Automatical generation of HAVING clause for conditions with entity attributes marked as "aggregate";
• Added: ReadOnly property for Query.Condition objects;

Requirements:.NET framework 1.1 or 2.0