64 results for "@tag:code-sample"

Aggregate data

/tutorials/aggregate-data

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

Query with OR operators

/tutorials/query-with-or-operators

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

Introduction to value editors

/fundamentals/about-data-editors

Each condition in query consists of 3 parts: attribute (field), operator and values (one or more). By default when a user clicks on ”[enter value]” link in a condition he/she is presented with an edit box actually to type the value. EasyQuery allows you to assign a value editor for each attribute or operator in your model - so your users will be able to use other methods of entering values

Customizing common SQL clauses

/how-to/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

/how-to/build-query-by-code-on-clientside

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

/tutorials/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

/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

Processing custom value editors in EasyQuery JS

/how-to/custom-value-editor

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

How to save/load queries to/from database

/how-to/mvc-save-load-query-database

Find out how to change this default behavior and save/load queries to any other storage

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.

Getting started for EasyQuery ASP.NET MVC

/getting-started/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

/how-to/adhoc-reporting-in-your-webapp

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

/how-to/customizing-sql-query-formats

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

Simple query over one table

/tutorials/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

/release-notes/upgrade-from-3.x-to-4.0

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

Navigate through query conditions

/how-to/run-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

/how-to/build-data-model-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

/getting-started/asp-net-webforms

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

Operators page

/data-model-editor/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

/how-to/hide-entities-and-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

/how-to/add-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

/how-to/mvc-query-builder-view-in-your-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

/release-notes/upgrade-from-2.x-to-3.0

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

Query with table joins

/tutorials/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

/tutorials/query-builder-ui-localization

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

How to limit columns from duplication

/how-to/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

/how-to/anti-forgery-token

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

About product keys

/getting-started/product-key

This article about using a product key that allows you to unlock all the features of EasyQuery library.

Getting started for Windows Forms

/getting-started/winforms

This article shows how to apply EasyQuery.NET to your application

Navigate through data model entities and attributes

/how-to/run-through-data-model-entities

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

How to make field to field comparison

/how-to/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

/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

Working with table aliases

/data-model-editor/working-with-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.

Exporting query results

/tutorials/exporting-query-results

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

Getting started for Silverlight

/getting-started/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

/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

Getting started for WPF

/getting-started/wpf

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