Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Query Builder Control

run query builder Query Builder
Customize the 'SELECT' statement on the client side using the in-browser Query Builder.
Company Name
Contact Name
Product Name
Unit Price
Exotic LiquidsCharlotte CooperLondonUKChai18.0000
Exotic LiquidsCharlotte CooperLondonUKChang19.0000
Exotic LiquidsCharlotte CooperLondonUKAniseed Syrup10.0000
New Orleans Cajun DelightsShelley BurkeNew OrleansUSAChef Anton's Cajun Seasoning22.0000
New Orleans Cajun DelightsShelley BurkeNew OrleansUSAChef Anton's Gumbo Mix21.3500
Grandma Kelly's HomesteadRegina MurphyAnn ArborUSAGrandma's Boysenberry Spread25.0000
Grandma Kelly's HomesteadRegina MurphyAnn ArborUSAUncle Bob's Organic Dried Pears30.0000
Grandma Kelly's HomesteadRegina MurphyAnn ArborUSANorthwoods Cranberry Sauce40.0000
Tokyo TradersYoshi NagaseTokyoJapanMishi Kobe Niku97.0000
Tokyo TradersYoshi NagaseTokyoJapanIkura31.0000
Page 1 of 8 (77 items)Prev12345678Next

This demo illustrates how to supply the Grid View with data using the DevExpress ASP.NET MVC Query Builder control. This control allows you and your end-users to visually construct SQL 'SELECT' statements.

Click Query Builder above the grid view control to start customizing a 'SELECT' statement.

Use the Save button on the Query Builder toolbar to generate a SQL string and assign it to the Grid View's SelectCommand property.

Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxGridViewDemos