Mehul Harry's DevExpress Blog

This Blog

News


Mehul Harry is the DevExpress Web Program Manager. Follow him on twitter: @Mehulharry

Subscribe (RSS, Email)

Archives

ASP.NET MVC - Query Builder (v18.1)

Use the powerful DevExpress Query Builder with your DevExpress ASP.NET MVC controls, starting with the v18.1 release!

The Query Builder component allows an end-user to visually build queries using our UI controls. This saves the end-user from learning and writing SQL statements. Once the queries are built, you can then apply those queries on existing DevExpress controls like the ASP.NET MVC GridView. This puts the power of ad-hoc querying in your end-users control.

Here's a screenshot of the MVC Query Builder control, click on the image for a larger version:

The Query Builder was first introduced as part of our XtraReports' Web Report Designer and then was released as a separate control for ASP.NET Web Forms. Many of you have requested this as an independent control for ASP.NET MVC and now it's available in v18.1 release.

Features

We've packed a ton of great features in the DevExpress ASP.NET MVC Query Builder:

  • The database schema is automatically obtained and displayed within the QueryBuilder's UI. You can also customize the database schema at runtime by implementing a custom schema provider to reduce the list of tables and views available for an end-user
  • Relationships between tables are automatically resolved based on foreign keys
  • An enhanced filter editor features the Advanced Mode allowing you to specify a filter string manually instead of using a visual editor. The code completion is available
  • Ability to visually shape retrieved data (sort, group and filter), which automatically edits 'ORDER BY', 'GROUP BY' and 'WHERE' query clauses
  • Ability to use the 'SELECT DISTINCT' clause
  • Aggregation of columns’ data
  • Preview entire SELECT statement
  • Preview the Query execution results

How do you plan to use the Query Builder in your ASP.NET MVC projects? Drop me a line below.

Thanks!


Email: mharry@devexpress.com

Twitter: @mehulharry

Published Apr 11 2018, 08:00 AM by
Filed under: , ,
Bookmark and Share

Comments

Abdul Qayyum 5

Hi it is must be avaiapble in WinForms controls also as separately

April 11, 2018 9:14 AM

Anurag Mahato

What about WPF

April 11, 2018 9:45 AM

Manuel Grundner [DevExpress MVP]

Nice! Will throw away my own Implementation after this Release! :)

April 11, 2018 9:49 AM

Dmitry Tok (DevExpress Support)

@Abdul: We have the following Code Example demonstrating how to invoke Query Builder in WinForms app: www.devexpress.com/.../how-to-use-the-query-builder-in-a-winforms-application. Would you please check if the proposed solution meets your requirements?

@Anurag: I do recall you were asking this question in our Support Center and while the control is not available as a separate one, we have a solution in the www.devexpress.com/.../are-there-any-plans-to-add-the-new-asp-net-query-builder-to-wpf thread (we've also uploaded there an example with v17.2). Didn't you find this approach useful, or perhaps, there are some disadvantages?

@Manuel: Nice to hear that! Let us know about your experience once you are able to check this new control and do not hesitate to share any further improvement ideas with us.

April 13, 2018 9:41 AM

About Mehul Harry (DevExpress)

Mehul Harry is an ASP.NET technical evangelist at Developer Express. You can reach him directly at mharry@DevExpress.com. You can also follow him on Twitter: http://twitter.com/mehulharry
LIVE CHAT

Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

FOLLOW US

DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, Delphi, HTML5 or iOS & Android development. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2018 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners