63 results for "@tag:code-sample"

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)

Aggregate data


From this article you will see how to aggregate (count, sum, etc.) data in your queries.

Query with OR operators


In this article, you will learn how to build queries that contain both AND and OR operators.

Introduction to value editors


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

Customizing common SQL clauses


This article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)

Build query by code on the client-side


Here you can find an example of JavaScript code with explanation how to add columns to a current query on client-side.

Paging in query results


Paging can make your work with query more convenient. And here is detailed instruction on how to use it.

Using EqMvcDemoEF sample with your own DB context


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

Processing custom value editors in EasyQuery JS


Here you can find tips how to value editor setup and how to value editor widget

Date/time values formatting


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

Getting started for EasyQuery ASP.NET MVC


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

Adhoc reporting page in your web application


This article describes how to implement the adhoc reporting functionality (similar to the one from our live demos) in your own project.

Customizing SQL query formats


Detailed instruction with various examples of how to operate with different query formats.

Simple query over one table


How to build a simple query with 1-2 conditions over one table (entity)

Upgrading from version 3.x to 4.0


How to upgrade your project from version 3.x to version 4.0 of EasyQuery

Navigate through query conditions


A code snippet which demonstrates how to run through all conditions in your query

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

Getting started for ASP.NET WebForms


Here you can find the instructions how to add EasyQuery components into your ASP.NET WebForms project

Operators page


This article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).

Hide some entities and/or attributes


Here we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model

Add a new aggregate function


EasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.

Add query builder page from our MVC sample project in your own app


This article described how to set up an advanced search page in your web-application using EqMvcDemoDB project as a template.

Upgrading from version 2.x to 3.0


How to upgrade your project from version 2.x to version 3.0 of EasyQuery

Query with table joins


An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.

Localization of query builder's UI


In this article, you can find two methods of localization of EasyQuery components

How to limit columns from duplication


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

Setting anti-forgery token for AJAX requests from EasyQuery widgets


Here you can find out how to strengthen security of your project using antiForgeryToken option.

EasyQuery License key


Here we describe how to apply the product key that you get after purchasing the license and which allows you to unlock all the features of EasyQuery library.

Navigate through data model entities and attributes


A code snippet which demonstrates how to run through data model entities and attributes

How to make a field to field comparison


The instructions on how to add a condition which compares a field against another field instead of constant value.

Using MS SQL instead of Access in WebDemo sample project


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

Working with table aliases


In this article, we provide all the information needed to use aliases properly. There is an explanation, what for aliases are in the DME and an example of using it.

Processing custom value editors in EasyQuery JS


First, of you will need to assign a custom (user-defined) value editor for some attribute or operator in your data model. You have to ways to do it: Run Data Model Editor (DME). Select an entity attribute which you want to assign custom value editor to. You can add a custom editor to any entity attribute in your model at run-time. Here is an example of very simple value editor in TypeScript.

Managing data formats


This article shows how to implement some particular tasks with your query

Exporting query results


Detailed instruction on how to perform additional functionality while dealing with EasyQuery results.

Getting started for Silverlight


This article will guide you through all steps necessary to apply EasyQuery.NET to your application, with extract examples

EasyQuery ASP.NET - using jQuery widgets on WebForms project


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

Getting started for WPF


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