Dynamic populating of value lists in WinForms or WPF editions

Example of how to solve this problem

Dynamically populate value lists by information from other conditions

Suppose 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.

Dynamically populate lists by information from other conditions — WebForms

A code snippet which demonstrates how to execute this task

Upgrading to 5.x: WinForms and WPF projects

This tutorial describes how to modify your old Windows Forms or WPF project with EasyQuery 3.x to upgrade to EasyQuery version 5.2.0 (or higher). Please note. Version 5.2.0 of EasyQuery works only on .NET Framework 4.6.1 or higher. So, if your project targets a lower version of .NET Framework - you will need to update Target Framework for your project first (right-click on the project in Solution

Korzh.EasyQuery.Wpf

EasyQuery visual controls for Windows Presentation Foundation (WPF)

Dynamic PHP query builder with EasyQuery

Dynamic PHP query builder with EasyQuery

Korzh.EasyQuery.WinForms

EasyQuery Windows Forms controls

Korzh.EasyQuery.Wpf namespace

Setup custom value editor — WinForms

Here you can find all steps you need to perfom

Building data model dynamically by DB meta-information

It'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

Step-by-step instruction how to setup SQL LIST value editor.

Building data model dynamically by information from a DataTable

Example of how to build data model by certain information from DataTable

Getting started for WPF

You will be able to apply EasyQuery WPF to your application, performing all the instructions in this article

Korzh.EasyQuery.WinForms namespace

Korzh.EasyQuery.WinForms.ModelEditor

EasyQuery Model Editor controls for Windows Forms

Creating 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.

Value Editors

Here you can find the full list of editors and choose any you need in your work with Data Model:

Getting started for WPF

Getting started tutorial on how to use EasyQuery components to implement an ad-hoc query builder in WPF application.

Building dynamic queries with EasyQuery and Entity Framework

Here 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)

Replace "value" element in QueryPanel's conditions — WinForms

Here is a step-by-step description what you need to achieve this goal