63 results for "@tag:code-sample"

Building dynamic queries with EasyQuery and Entity Framework

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

/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 AND and OR operators.

Introduction to value editors

/fundamentals/about-data-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

/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

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/version-3-x/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

/version-3-x/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.

EasyQuery License key

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

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

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

How to make a 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.

Processing custom value editors in EasyQuery JS

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

/tutorials/managing-data-formats

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

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/version-3-x/wpf

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