Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Query Builder Control

Company Name
 
Contact Name
 
City
 
Country
 
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

The DevExpress ASP.NET Query Builder (ASPxQueryBuilder) allows you to provide your end users with the capability to visually construct database system-specific 'SELECT' statements. The resulting SQL string can then be obtained on the ASPxQueryBuilder.SaveQuery event via the SelectStatement event parameter.

In this demo, ASPxQueryBuilder is used to compose an MS Sql-specific 'SELECT' statement. The resulting query is executed against an MDF database using an SqlDataSource, and the data obtained as the result of the query execution is displayed in an ASPxGridView control.

To start customizing a 'SELECT' statement, click QUERY BUILDER above the grid view control.

Click the Save and Close button on the Query Builder toolbar to generate the SQL string and assign it to the data source control's SelectCommand property.

Collapse/Expand
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
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos

Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).
All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.