use-cases/$s/@tag:webforms | EasyQuery.NET documentation

This 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-webforms

Describes the steps you need to perform for applying EasyQuery ASP.NET to your MVC or WebForms project

EasyQuery ASP.NET - using jQuery widgets on WebForms project

/getting-started/sample-webforms-javascript-webservice

In this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples

asp-net webforms web-service javascript widgets code-sample

Using parameters in query conditions

/how-to/parameters-in-query-conditions

This article explains how to work with parameterized conditions.

data-model asp-net asp-net-mvc parameters sql code-sample javascript

Using EqMvcDemoEF sample with your own DB context

/getting-started/sample-mvc-entity-framework-new-dbcontext

This article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class

asp-net mvc entity-framework dbcontext code-sample

Using MS SQL instead of Access in WebDemo sample project

/getting-started/sample-webforms-change-to-mssql

In this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access

asp-net webforms sql-server oledb code-sample

Building data model dynamically using code (version 3.x)

/how-to/build-data-model-by-code

Here you can find all steps you need to perform

data-model code-sample tables links connection

Version 5.2 release notes

/release-notes/version-5-2

Version 5.2 of EasyQuery not only brings some improvements to the .NET Core edition, it;s also the first release of 5.x branch for all other editions of EasyQuery which uses on .NET Framework 4.x and still were on 3.x branch until now: WinForms, WPF and ASP.NET 4 editions. There are 2 big changes in ASP.NET edition of EasyQuery which affects your MVC project when you upgrade to EasyQuery version 5.2.0 or higher. Starting from version 5.2.0 EasyQuery for ASP.NET uses the latest version of the client-side library (EasyQuery.JS 5.1.8 for now) which is the same that is used in ASP.NET Core edition. The same as for MVC applications, for WebForms we now use the latest version of EasyQuery.JS library on the client-side and a WebAPI controller on the server-side. Bug fixed: Disabled columns were included into GROUP BY section Bug fixed in WPF edition: Empty column title on edit Bug fixed in WPF edition: Wrong behavior of "Duplicate condition" operation If you are upgrading from version 5.x for ASP.NET Core - you just need to change the version numbers of all EasyQuery NuGet packages you are using to 5.2.0 and the version of the EasyQuery script files (or NPM packages) to 5.1.8 NB : For the users of EasyQuery script bundles (like eq.all.min.js ) published on our CDN You will also need to modify the full path to the EasyQuery classes and add ui namespace to it.

Date/time values formatting

/how-to/date-time-formatting

In this article, you can find instructions how to set up different types of date & time formats, with code examples.

formats date-time sql grid code-sample

Version 5.0 release notes

/release-notes/version-5-0

Version 5.0 is a completely rewritten major update of EasyQuery which now can be used in any ASP.NET Core (version 2.0 and higher) project and with almost any frontend platform (MVC, Razor pages, Angular, React, Vue, etc). There are a lot of changes both on the server-side part and in the client-side library (EasyQuery.JS). Below we will describe the most important ones: Core library

EqExpression class

/api-reference-5x/korzh-easyquery-namespace/eqexpression-class

Represents common expression object.

Working with data models in EasyQuery

/getting-started/working-with-data-model

This article will guide you through all issues about working with data models in EasyQuery library. How to load it from the DbContext or from your DB connection, or now to create a new one using Data Model Editor.

data-model database tables connection links sql-server dme

Version 5.3 + EasyQuery.JS 6.0 release notes

/release-notes/version-5-3

The biggest change in this release is a new major update (version 6.0) of JavaScript library (EasyQuery.JS) used with ASP.NET or ASP.NET Core editions of EasyQuery. Version 5.3 of EasyQuery contains rather small improvements in the core libraries and all .NET editions. Community edition packages include @easyquery/core , @easyquery/ui . All license owners of EasyQuery for ASP.NET or EasyQuery for ASP.NET Core automatically got a license for EasyQuery.JS as well. to set your key, now for ASP.NET Core edition it will be Respectively, you should use Korzh.EasyQuery.AspNet...

EqExpression class

/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-class

Represents common expression object.

Getting started for EasyQuery ASP.NET MVC

/getting-started/version-3-x/asp-net-mvc

This article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application

asp-net mvc javascript data-model controller client-side get-start dme code-sample

Copying the EasyQuery's code from a sample to your project

/getting-started/from-sample-to-your-own-project/copying-the-easyquerys-code-from-sample-to-your-project

If you have already modified one of our sample projects to make it work with your DB, the next step will be to copy the EasyQuery's code to your own solution. This article describes how to do it.