Is extremely useful when you need...

  • Data filtering UI

    Whenever you show the grid with more then several rows of data, your users may need to filter the data somehow. Usually you don't know how exactly they need to filter the data. Let them use EasyQuery and relax! They will do the job easily and will be happy.

  • Advanced search form

    What if your users need to search by many different parameters and in various combinations? Typical search form looks like a mess of different controls related to one database field each. It may occupy the full screen but even in this case it may not cover all possible combinations of conditions.

    Do your users fated to use such an ugly forms? Not with EasyQuery!

    The EasyQuery interface is laconic and intuitive, it allows to build almost any combination of conditions your users could wish for.

  • Ad-hoc reporting

    Have you ever heard from your customer: "We need to change 3 reports and create 5 new"? Have you calculated the time and energy spent for all these trifles?

    With EasyQuery you may answer: "Do it yourself, m... mister!" Just give them ability to build/change queries for reports, save and load them, draw charts and export results.

...or any other end-user interface related to data manipulating

Overview

See EasyQuery in action

EasyQuery Editions

EasyQuery ASP.NET

Ad-hoc query builder is a useful addition to WebForms and the MVC web-app that requires some functionality for advanced searching and/or filtering. EasyQuery ASP.NET components provide your application with a powerful and easy-to-use interface for visual query building. It helps your users build their own queries and reports without the necessity to call for additional assistance or to contact your support team.

  • All kinds of ASP.NET projects are supported: WebForms, AJAX, MVC.
  • Friendly, natural language query builder UI: users do not need to know about your tables, links, fields or any other DB-related things.
  • Programming language: C# (can be used in VB.NET or any other .NET language as well).
  • Supported databases: MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL or any other database as well as object-relational-mapping solutions (like Entity Framework)
  • Supported .NET framework versions: 2.0 and higher.
Download free trial Pricing

EasyQuery WinForms

Dynamic SQL query builder will be a good addition for any Windows Forms application (especially a database-related one). EasyQuery WinForms is designed to help you with this task. As a result, your C# or VB.NET application get an end-user-oriented query builder which helps your users to run any queries they can imagine without any additional assistance from your support team. EasyQuery components allow them to build even complex queries or filter expressions visually simply by assembling a phrase in natural language.

  • Natural language user interface for query building.
  • Distributed as 100% pure .NET assemblies.
  • Written in: C# (can be used in VB.NET or any other .NET language as well).
  • Databases: MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL or any other database as well as object-relational-mapping solutions (like Entity Framework)
  • .NET framework versions: 2.0 and higher
Download free trial Pricing

EasyQuery JavaScript

If your web-application works with data - we're sure it needs EasyQuery to be added. EasyQuery.JS widgets give you a powerful and easy-to-use interface for visual query building. You may use it to provide advanced searching, filtering or report-building functionality in your application. Your users will be able to build their own queries and reports - no support calls, no additional assistance. It doesn't matter what language or platform do you use: if your web-application uses JavaScript - you will be able to apply EasyQuery.JS. All known databases are supported.

How it works

  • You create a data model on the base of your database structure. There is a special utility that helps you to build the data model - Data Model Editor
  • You place and setup EasyQuery.JS widgets on your web-page. These widgets provide the end-user interface to build query visually.
  • The widgets communicate with server-side script that processes all AJAX requests from widgets. We have developed such a script for some platforms. If your platform is not supported yet - you can easily write your own script.
  • The main goal is to generate the SQL query. There is a special SQL query builder web-service we created for this task. You pass the JSON received from the widget - and get back the correct SQL statement for you database.
  • Now you need to execute this SQL statement over your database, return the result-set back to the client-side in some format and show that result-set to user in a form of some data grid or chart.

See also

Download free trial

EasyQuery Silverlight

EasyQuery Silverlight will be an useful addition to any Silverlight project which works with some database. This library allows you to include end-user-oriented web-based query builder into your page(s) and helps your users to build their own reports without necessity to contact your support team.

  • Distributed as 100% pure Silverlight assemblies.
  • Silverlight versions: 4.0 and 5.0.
  • All types of databases are supported.
Download free trial Pricing

EasyQuery WPF

EasyQuery WPF will be a good addition for any database application built on top of Windows Presentation Foundation library. Our components allows you to include end-user-oriented query builder into your program and helps your users to build and run any queries by their own without contacting your support team.

Download free trial Pricing

EasyQuery Delphi/VCL

SimpleQuery is a Delphi (VCL) edition of our EasyQuery product family. This component library allows you to integrate end-user-oriented query builder into your Delphi or C++Builder project. Try it now: it will take only 20-30 minutes to include SimpleQuery components into your existing project!

  • Programming language: Delphi Pascal.
  • Distributed as 100% pure Delphi packages.
  • Supported Delphi versions: 6.0 and higher.
  • Supported databases: Paradox, MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL as well as any other database which can be used with Delphi or C++ Builder.
Download free trial Pricing

Supported Technologies

Platforms

  • ASP.NET WebForms
  • ASP.NET MVC
  • WinForms
  • WPF
  • Silverlight

Databases

  • SQL Server
  • MySQL
  • Oracle
  • MS Access
  • Postgre SQL
  • etc.

Query Languages

  • SQL
  • Entity SQL
  • Linq
  • Filter expression

Next Steps

Try EasyQuery
Free trial with dedicated technical support
Read documentation
User's guide, knowledge base, API reference
Buy EasyQuery
Check out the pricing options

Our Customers

...and what they say

Latest news

2016-08-17

EasyQuery 3.7.3 release

This version of EasyQuery has a number of new features and fixed bugs, listed below. Among the most important updates - users now allowed to define additional list of tables for each operator, and they will be included into result SQL. This feature is actual for all EasyQuery experiences: ASP, Silverlight, WIN, WPF. To read more information just click on the title.

2016-03-14

EasyQuery 3.7.2 release

New features are available in EasyQuery 3.7.2. Most of them are actual for EasyQuery ASP edition. But there are also those, acceptable for all ASP, Silverlight, WIN and WPF, as Oracle Managed Data Access connector support in Data Model Editor. Also we've fixed a number of bugs, such as wrong behavior in Value Editor Settings dialog. Click on the title to read full list of updates.