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.
Previous versions' tutorials (obsolete)
/tutorials/version-3-x-tutorialsThis section contains the tutorials that we written for older versions of EasyQuery and most probably are obsolete now.
Version 5.0 release notes
/release-notes/version-5-0Version 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
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-projectIf 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.
Pages class
/api-reference-5x/korzh-easyquery-razorui-namespace/pages-classContains the settings for the default pages from EasyQuery Razor UI library
Pages class
/api-reference/korzh-easyquery-razorui/korzh-easyquery-razorui-namespace/pages-classContains the settings for the default pages from EasyQuery Razor UI library
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 Core + MVC or Razor pages
/getting-started/aspnet-core-razorHow to use install EasyQuery to your ASP.NET Core project with Razor Pages or MVC.
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.
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.
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)
How it works
/fundamentals/how-it-worksThe above scheme shows the general internal structure of the library and the main principles of its work. EasyQuery components All EasyQuery classes and components can be divided into two main parts: logical part (DataModel, Query, SqlQueryBuilder). the visual part (QueryPanel, ColumnsPanel, etc.). The logical part is responsible for the internal representation of data structures and user
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
Version 5.2 release notes
/release-notes/version-5-2Version 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.
Obsolete (for version 3.x or lower)
/how-to/obsolete-tutorialsThis section contains the tutorials for previous versions of EasyQuery.
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.
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.