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)
Customizing SQL query formats
/how-to/customizing-sql-query-formatsDetailed instruction with various examples of how to operate with different query formats.
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
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.
SqlFormats class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/sqlformats-classRepresents different formats of SQL statements.
EqExpression class
/api-reference-5x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
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
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.
QueryFormats class
/api-reference-4x/korzh-easyquery-namespace/queryformats-classRepresents different formats of statements.
EqExpression class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
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.
CustomSqlExpr class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/customsqlexpr-classRepresents a custom SQL expression
QueryFormats class
/api-reference-5x/korzh-easyquery-namespace/queryformats-classRepresents different formats of statements.
EasyQuery.NET 5.4.1 + EasyQuery.JS 6.1.0 release notes
/release-notes/easyquery-net-5-4-1-easyquery-js-6-1-0Better performance It takes less time and memory for the new grid to render the same amount of data. It's easier now to define the styles for different parts of the grid and to set custom styles for each column or even for a particular cell. The code of our new grid was moved to a separate NPM package ( @easydata/ui ) and so, can be used even without EasyQuery at all. This new widget allows us to define different views for your result set. As already said, our server-side API code (EasyQuery middleware for .NET Core and WebAPI controller for .NET 4.x) was updated to support the new data format and other changes in EasyQuery.JS 6.1.0 Version 5.4.1 also includes a possibility to save/load queries to/from the files on the visitor's computer.
CustomSqlExpr class
/api-reference-5x/korzh-easyquery-db-namespace/customsqlexpr-classRepresents a custom SQL expression
EntitySqlQueryBuilder class
/api-reference-5x/korzh-easyquery-db-namespace/entitysqlquerybuilder-classLets you build Entity SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-5x/korzh-easyquery-db-namespace/dbquery-class) object
EntitySqlQueryBuilder class
/api-reference-4x/korzh-easyquery-db-namespace/entitysqlquerybuilder-classLets you build Entity SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object
SqlQueryBuilder class
/api-reference-4x/korzh-easyquery-db-namespace/sqlquerybuilder-classLets you build SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object
SqlQueryBuilder class
/api-reference-5x/korzh-easyquery-db-namespace/sqlquerybuilder-classLets you build SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-5x/korzh-easyquery-db-namespace/dbquery-class) object