Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Collapse]Query Builder
   [Expand]Getting Started
   [Expand]Visual Elements
    Binding to Data
    Obtaining the Resulting Query
    Localize the Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Query Builder

ASP.NET Query Builder is an HTML5/JS based control that you can use to allow your end-users to create and edit SQL queries. As of the 17.1 release, the ASP.NET Query Builder control is on its CTP (Community Technology Preview) stage.

The rich user interface of the Query Builder allows fast and easy constructing of SQL queries. All elements of an SQL query are represented visually in the Query Builder interface and can be adjusted even by an end-user unfamiliar with SQL and its provider-specific dialects. The Query Builder control is capable of generating complex SELECT statements incorporating query clauses for data filtering, grouping, and sorting, which you can utilize to supply various data-aware web controls (such as Grid View or Chart Control) with data.

Note

Note that because the ASP.NET Query Builder is currently on its CTP stage, some aspects of its functionality described in this document may change in the release version.

Getting Started

To learn the basics of the DevExpress ASP.NET Query Builder, take a look at the following lessons.

Data Binding

The Query Builder is a data-aware control and requires a valid data connection to operate.

Using a connection to a database, the Query Builder control automatically obtains database schema information to populate its Tables List and resolves table relations based on foreign keys. Moreover, having access to database metadata, the Query Builder control is capable of generating queries in a provider-specific dialect of SQL.

Query Generation

As the result of its work, the Query Builder control produces a string containing the final SQL statement and a SelectQuery, which stores a high-level object model for a SQL query and can be reopened in the Query Builder for further editing if required. A final SQL query contains a 'SELECT' statement and optionally 'WHERE', 'ORDER BY' and 'GROUP BY' query clauses.

Visual Interface

The Query Builder control provides a rich user interface, which includes the following visual elements.

How would you rate this topic?​​​​​​​