Building dynamic queries with EasyQuery and Entity Framework
/tutorials/dynamic-queries-with-easyquery-and-entity-frameworkHere we describe how EasyQuery helps to implement a query building UI for creating custom, dynamic queries in .NET projects which use Entity Framework (6.x)
Aggregate data
/tutorials/aggregate-dataFrom this article you will see how to aggregate (count, sum, etc.) data in your queries.
Query with OR operators
/tutorials/query-with-or-operatorsIn this article, you will learn how to build queries that contain both AND and OR operators.
Introduction to value editors
/fundamentals/about-data-editorsFor example, value editor allows you to define a list of available values - so your users will be able to select the value from a drop-down list. "Custom list" value editor raises an event which can be processed either on the client-side or on the server. All other editions of EasyQuery (WinForms, WebForms, WPF or Silverlight) has ListRequest event in QueryPanel control which is raised when a user adds an attribute (or operator) with Custom List or SQL list value editor assigned to that attribute/operator. Here we show how you can filter the returned list according to the value specified for some other attribute. If such condition is defined - we get the value (country code) from it and use that value as a filter for the list of regions.
Customizing common SQL clauses
/how-to/customizing-common-sql-clausesThis article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)
Build query by code on the client-side
/how-to/build-query-by-code-on-clientsideHere you can find an example of JavaScript code with explanation how to add columns to a current query on client-side.
Paging in query results
/tutorials/paging-in-query-resultsPaging can make your work with query more convenient. And here is detailed instruction on how to use it.
Using EqMvcDemoEF sample with your own DB context
/getting-started/sample-mvc-entity-framework-new-dbcontextThis article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class
Processing custom value editors in EasyQuery JS
/how-to/custom-value-editorHere you can find tips how to value editor setup and how to value editor widget
JavaScript widgets formats and settings (Webforms)
/tutorials/javascript-widgets-settings-formats-webformsHow to set up column formats and change default settings of the table.
Gridview filtering with EasyQuery ASP.NET (WebForms)
/use-cases/gridview-filtering-with-easyquery-aspnet-webformsGridview filtering with EasyQuery ASP.NET (WebForms)
Building data model dynamically by information from a DataTable
/how-to/build-data-model-by-info-from-datatableExample of how to build data model by certain information from DataTable
Date/time values formatting
/how-to/date-time-formattingIn this article, you can find instructions how to set up different types of date & time formats, with code examples.
Getting started for EasyQuery ASP.NET Core (version 4.x)
/getting-started/asp-net-core-v4Describes how to setup EasyQuery in ASP.NET Core web application
Getting started for EasyQuery ASP.NET MVC
/getting-started/version-3-x/asp-net-mvcThis article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application
Adhoc reporting page in your web application
/how-to/adhoc-reporting-in-your-webappThis article describes how to implement the adhoc reporting functionality (similar to the one from our live demos) in your own project.
Customizing SQL query formats
/how-to/customizing-sql-query-formatsDetailed instruction with various examples of how to operate with different query formats.
Simple query over one table
/tutorials/query-over-one-tableHow to build a simple query with 1-2 conditions over one table (entity)
Upgrading from version 3.x to 4.0
/release-notes/upgrade-from-3.x-to-4.0How to upgrade your project from version 3.x to version 4.0 of EasyQuery
Navigate through query conditions
/how-to/run-through-query-conditionsA code snippet which demonstrates how to run through all conditions in your query
Building data model dynamically by DB meta-information
/how-to/build-data-model-by-db-meta-informationIt's easier to fill your model right in the code directly from your database, using meta-information
How to setup SQL LIST value editor in WinForms app
/how-to/SQL-LIST-value-editor-in-winforms-appStep-by-step instruction how to setup SQL LIST value editor.
Dynamically populate lists by information from other conditions — WebForms
/how-to/dynamically-populating-list-webformsA code snippet which demonstrates how to execute this task
Setup custom value editor — WinForms
/how-to/custom-value-editor-winformsHere you can find all steps you need to perfom
Getting started for ASP.NET WebForms
/version-3-x/getting-started/asp-net-webformsHere you can find the instructions how to add EasyQuery components into your ASP.NET WebForms project
Operators page
/data-model-editor/operators-pageThis article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).
How to remove "Powered by..." link (full version only)
/how-to/mvc-remove-powered-byFull instruction of how to remove “Powered by EasyQuery” link
Hide some entities and/or attributes
/how-to/hide-entities-and-attributesHere we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model
Add a new aggregate function
/how-to/add-aggregate-functionEasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.
Add query builder page from our MVC sample project in your own app
/how-to/mvc-query-builder-view-in-your-appThis article described how to set up an advanced search page in your web-application using EqMvcDemoDB project as a template.
Upgrading from version 2.x to 3.0
/release-notes/upgrade-from-2.x-to-3.0How to upgrade your project from version 2.x to version 3.0 of EasyQuery
Replace "value" element in QueryPanel's conditions — WinForms
/how-to/replace-value-elementHere is a step-by-step description what you need to achieve this goal
Query with table joins
/tutorials/query-with-table-joinsAn example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.
Building data model dynamically using code (version 3.x)
/how-to/build-data-model-by-codeHere you can find all steps you need to perform
Localization of query builder's UI
/tutorials/query-builder-ui-localizationIn this article, you can find two methods of localization of EasyQuery components
How to add a column with the same attribute as in newly added condition
/how-to/add-column-by-condition-attributeA code snippet which demonstrates how to do this task
How to limit columns from duplication
/how-to/how-to-limit-columns-from-duplicationHow to limit columns from duplication in MVC project, so when you add a column that is already used in a report it won’t be added again.
Setting anti-forgery token for AJAX requests from EasyQuery widgets
/how-to/anti-forgery-tokenHere you can find out how to strengthen security of your project using antiForgeryToken option.
EasyQuery License key
/getting-started/product-keyHere we describe how to apply the product key that you get after purchasing the license and which allows you to unlock all the features of EasyQuery library.
Getting started for Windows Forms
/getting-started/version-3-x/winformsThis article shows how to apply EasyQuery.NET to your application
Dynamic populating of value lists in WinForms or WPF editions
/how-to/dynamic-populating-value-list-winforms-wpfExample of how to solve this problem
Navigate through data model entities and attributes
/how-to/run-through-data-model-entitiesA code snippet which demonstrates how to run through data model entities and attributes
How to make a field to field comparison
/how-to/field-to-field-comparisonThe instructions on how to add a condition which compares a field against another field instead of constant value.
Using MS SQL instead of Access in WebDemo sample project
/getting-started/sample-webforms-change-to-mssqlIn this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access
Working with table aliases
/data-model-editor/working-with-aliasesIn this article, we provide all the information needed to use aliases properly. There is an explanation, what for aliases are in the DME and an example of using it.
Using parameters in query conditions
/how-to/parameters-in-query-conditionsThis article explains how to work with parameterized conditions.
Adding columns and conditions with code
/how-to/add-columns-conditions-with-codeExample of code for adding columns and conditions
Processing custom value editors in EasyQuery JS
/how-to/processing-custom-value-editors-in-easyquery-jsFirst, of you will need to assign a custom (user-defined) value editor for some attribute or operator in your data model. You have to ways to do it: Run Data Model Editor (DME). Select an entity attribute which you want to assign custom value editor to. You can add a custom editor to any entity attribute in your model at run-time. Here is an example of very simple value editor in TypeScript.
Managing data formats
/tutorials/managing-data-formatsThis article shows how to implement some particular tasks with your query
Exporting query results
/tutorials/exporting-query-resultsDetailed instruction on how to perform additional functionality while dealing with EasyQuery results.
Getting started for Silverlight
/getting-started/silverlightThis article will guide you through all steps necessary to apply EasyQuery.NET to your application, with extract examples
EasyQuery ASP.NET - using jQuery widgets on WebForms project
/getting-started/sample-webforms-javascript-webserviceIn this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples
Getting started for WPF
/getting-started/version-3-x/wpfYou will be able to apply EasyQuery WPF to your application, performing all the instructions in this article
Localization of EasyQuery widgets (obsolete)
/tutorials/version-3-x/javascript-widgets-localizationThis article shows how to localize widgets, with extract examples
How to add an extra condition to your query
/how-to/add-extra-conditionTwo possible ways of resolving this task