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