Active Query Builder  »  Active Query Builder for .NET  »  Active Query Builder ASP.NET Edition

Product summary
Latest version:
...
History of changes
Price from:
$599
All purchase options
Download free trial

Active Query Builder Live Demo

Online Visual SQL Query Builder for ASP.NET and other environments

Active Query Builder ASP.NET is a true online HTML Visual SQL Query Builder component. It lets build complex SQL queries with unions and sub-queries online in a friendly visual interface.

Active Query Builder helps organize a full-featured environment to work with queries and the result query data by providing means for pre- and post- query building user experience.

With Active Query Builder you can let users see the data during the query building process by organizing the query result data preview for the currently edited sub-query, so users understand if their queries give the expected results.

Visual SQL Query Builder for any web programming environment

Need an Online Visual Query Builder for Java, PHP, Ruby, NodeJS, Python, Perl or any other server-side web development technology?

Have a look at the Active Query Builder Web API project. It lets provide a convenient data browsing web interface for users having no idea about what SQL language is.

To build a query

  • Drag the needed objects from the Database Schema View at the left to the Design Pane. Joins between objects will be created automatically according to the foreign keys defined in the database. Users can create joins by dragging a field from one object to another.
  • Mark the fields for which you want to add columns in your query. To add an expression (concatenate strings, use SQL functions, etc.), type it to the Expression column of the Query Columns Grid (below the Design Pane).
  • Specify sorting, define grouping and aggregate functions for columns, give descriptive names, add conditions to filter data in the Query Columns Grid.
  • Specify query and join properties using the Properties Bar panel which tab is visible to the right of Design Pane.

Read the User's guide to learn how to work with unions and sub-queries.

To work with the query text, scroll down the page to the tabs.

  • To parse a query, paste the text to the SQL Text Editor on the first tab or edit the existing query text and click the green round button at the right-bottom corner of the editor.
  • To edit the text of the currently visible sub-query, switch to the second tab.
  • To preview the sub-query result data, switch to the third tab.

To browse the result query data, switch to the Query Results tab.

SQL Syntax Server version
Loading...
First 10 records of the current subquery resultset
https://www.jqwidgets.com
Text of the entire SQL query.
Text of the currently visible subquery. May include multiple SELECT statements united with set operators. (UNION, EXCEPT, INTRESECT)

Specify values for parameters found in the query and click the button

Please wait....

Active Query Builder lets replace unintelligible object and field names with friendly aliases. The user sees friendly names in the Database Schema View, in the Query Builder, and in the SQL query text. He can edit it and apply changes back to the Query Builder! The programmer gets the query with real names to execute it against a database server.

In this demo we took a snapshot of the database with the unintelligible object and field names and defined alternate names for them, so the database schema and the SQL queries become easily understandable. The user sees the SQL query text with friendly names on the first tab below the Query Builder. The SQL text on the second tab displays the query with real names. It shouldn't normally be visible to the end-user but provided in this demo to illustrate the principle of this feature.

Use Alternate Names
Please wait....
Query text without Alternate names

You can supplement your database schema with virtual objects and add virtual fields to existing objects. Hiding complex SQL expressions inside friendly named entities can simplify the database schema and user queries.

Virtual entities look like ordinary database objects and fields for end-users. The user sees them in the Database Schema View, in the Query Builder, and in the SQL query text. He can even edit the SQL text with virtual entities and apply changes back to the Query Builder! Virtual entities are substituted for their SQL expressions to execute the query against a database server, but this process goes seamlessly for the end-user.

In this demo, we've added the "OrderId_plus_1" and "CustomerCompanyName" virtual fields to the real Northwind.dbo.Orders table and two virtual objects called MyOrders and MyBetterOrders. The user sees the SQL query text with virtual entities on the first tab below the Query Builder. The SQL text on the second tab displays the SQL text with SQL expressions instead of virtual entities. It shouldn't normally be visible to the end-user but provided in this demo to illustrate the principle of this feature.

Please wait....
Query text with virtual objects expanded to their expressions
  • Active Query Builder provides the end-user with highly productive environment to work with SQL queries: displaying relevant metadata for the user, visual query designer to build and analyze SQL queries, professional SQL text editor, SQL text formatter and many other options.
  • Active Query Builder is essential assistant to work with data: entering of query parameter values, previewing of sub-query results, applying filters, sorting and grouping to result datasets, computing of totals.
  • Active Query Builder has powerful API to work with queries: SQL query parsing and analysis, limit access to tables and fields, or even to specific data records, programmatic correction and creation of new SQL queries.
  • Active Query Builder offers powerful means to tune the presentation of database schema to simplify complex database structure for the end-users.
Active Query Builder is available in the following editions:
Active Query Builder for WinForms
   » Windows Forms .NET 4.0+ component
Download free trial now
Active Query Builder for WPF
   » WPF .NET 4.0+ component
Download free trial now
Active Query Builder for ASP.NET
   » ASP.NET (WebForms, MVC, Core) component
Download free trial now
Active Query Builder for Java
   » Swing-based Java bean component
Download free trial now
Active Query Builder for Delphi
   » Delphi and C++ Builder component
Download free trial now