Dynamically populate lists by information from other conditions — WebForms
/how-to/dynamically-populating-list-webformsA code snippet which demonstrates how to execute this task
Dynamically populate value lists by information from other conditions
/how-to/dynamically-populating-lists-mvcSuppose we have a database with Customer entity which has Country and City attributes. For both these attributes we define the value editors which return the lists of available values (countries and cities correspondingly). Now let's imagine the user adds a condition with the Country attribute e.g. Hera the steps needed to implement such a functionality: Define a value editor for the City attribute as SQL LIST with Cities.@{{Customer.Country}} list name (here Customer.Country is the ID of the Country attribute in the Customer entity). Let's name it "CitesSqlValueList") and then in a value list resolver modify its SQL according the currently selected country and get the list of values using GetValueListAsync method of EasyQueryManager class: What's happening here.
Dynamic populating of value lists in WinForms or WPF editions
/how-to/dynamic-populating-value-list-winforms-wpfExample of how to solve this problem
Dynamic PHP query builder with EasyQuery
/use-cases/dynamic-php-query-builder-with-easyqueryDynamic PHP query builder with EasyQuery
JavaScript widgets formats and settings (Webforms)
/tutorials/javascript-widgets-settings-formats-webformsHow to set up column formats and change default settings of the table.
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
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
Creating data model dynamically with code
/how-to/create-data-model-dynamically-with-code-Data Model- object is an essential part of EasyQuery framework. However, sometimes you need to add some entities, entity attributes or operators to the existing model or to fill it from scratch using DB metadata information got from another source. In these cases, you can use EasyQuery API to build the model dynamically. Finally, we add entities and entity attributes. Here is an example of creatin a small data model: two tables (Customers and Orders) with one link between them, 2 entities (Customer and Order correpondingly) and a few attributes in each entity.
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)
Gridview filtering with EasyQuery ASP.NET (WebForms)
/use-cases/gridview-filtering-with-easyquery-aspnet-webformsGridview filtering with EasyQuery ASP.NET (WebForms)
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
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
Upgrading to 5.x: ASP.NET (MVC and WebForms) projects
/upgrade-instructions/net-framework-3-x-to-5-x-/asp-net-mvc-webformsThis tutorial describes how to upgrde your old ASP.NET MVC project with EasyQuery 3.x to EasyQuery version 5.2.0 (or higher). 1.2 Use NuGet Package Manager to install the following packages: Korzh.EasyQuery.AspNet4 Korzh.EasyQuery.EntityFramewok6 - if you are using Entity Framework 6.x Korzh.EasyQuery.DataExport - if you will need the data exporting functions Korzh.EasyQuery.MsSqlGate (or .MySqlGate or .OdbcGate depending on your DB) - if you need to load your model directly from DB connection. Finally, we need to make some modifications on our pages where we use EasyQuery scripts. Version 5.2.0 and higher of EasyQuery scripts will not need JQuery anymore, so you will be able to throw them away if they are not used in your own pages. Here is an example for "advanced search" view: To update your Web Forms page your will need to do the following 3 steps: Add EasyQuery scripts and styles on your page.
Getting started for ASP.NET 4
/getting-started/asp-net-4-mvc-or-webformsDescribes the steps you need to perform for applying EasyQuery ASP.NET to your MVC or WebForms project
Dynamic queries for ASP.NET Core projects with Entity Framework Core
/tutorials/dynamic-queries-ui-aspnet-core-entity-frameworkIt takes a few minutes to add a new page with all necessary UI for building dynamic queries and to setup a middleware that will process all requests from that page, convert those request to the queries to your DB and return the result set back for visualization. This step is necessary to get the trial keys for EasyQuery framework. One for ASP.NET Core packages and another one - for EasyQuery.JS scripts. To simplify this task EasyQuery includes a Razor UI library package ( Korzh.EasyQuery.RazorUI ) that contains several predefined pages which you can use in your projects. For example, there is an "advaced search" page which is available via /EasyQuery/AdvancedSearch .
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
Using parameters in query conditions
/how-to/parameters-in-query-conditionsThis article explains how to work with parameterized conditions.
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
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.
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