Screenshot Preview

Active Query Builder for .NET

by Active Database Software - Product Type: Component / ASP.NET WebForms / .NET WinForms / .NET Class / 100% Managed Code

Build complex SQL queries via an intuitive visual interface. Active Query Builder .NET Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder .NET Edition supports Visual Studio 2005, Windows.Forms environment (100% Managed Code, No direct Win32 interop calls). The new Active Query Builder ASP.NET Edition is designed for ASP.NET 2.0 environment, it provides native and easy way to embed visual query building functionality into your ASP.NET projects. Active Query Builder ASP.NET Edition is based on Active Query Builder .NET (Windows Forms) Edition. Utilizing the same powerful SQL parsing engine, it's end-user web interface has much in common with the ancestor.



Average Review:   based on 1 review.
From
$ 441.00

Our regular prices are shown below. Please logon to see your discounted prices.

Showing: All Prices | Renewals Only  in

Active Query Builder for .NET (v2.9) - Standard WinForms Subscription

Add to Cart $ 441.00 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833506
Add to Cart $ 295.47 1 Developer License, price per license for 2 Developers (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Min Qty: 2 Mfr. Part No: 2833506
Add to Cart $ 246.96 1 Developer License, price per license for 3 Developers (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Min Qty: 3 Mfr. Part No: 2833506
Add to Cart $ 882.00 4 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833854
Add to Cart $ 1,411.20 8 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833856

Active Query Builder for .NET (v2.7) - Standard ASP.NET Subscription

Add to Cart $ 441.00 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833630
Add to Cart $ 295.47 1 Developer License, price per license for 2 Developers (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Min Qty: 2 Mfr. Part No: 2833630
Add to Cart $ 246.96 1 Developer License, price per license for 3 Developers (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Min Qty: 3 Mfr. Part No: 2833630
Add to Cart $ 882.00 4 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833858
Add to Cart $ 1,411.20 8 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833860

Active Query Builder for .NET (v2.9) - Professional Subscription

Add to Cart $ 735.00 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833862
Add to Cart $ 492.45 1 Developer License, price per license for 2 Developers (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Min Qty: 2 Mfr. Part No: 2833862
Add to Cart $ 411.60 1 Developer License, price per license for 3 Developers (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Min Qty: 3 Mfr. Part No: 2833862
Add to Cart $ 1,470.00 4 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833866
Add to Cart $ 2,352.00 8 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833868
Add to Cart $ 1,029.00 Full Source Code (Requires Professional Developer License) Delivered via Download
Mfr. Part No: 2833870

Active Query Builder for .NET - Standard WinForms Subscription Renewal

Add to Cart $ 132.30 1 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833506
Add to Cart $ 264.60 4 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833854
Add to Cart $ 423.36 8 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833856

Active Query Builder for .NET - Standard ASP.NET Subscription Renewal

Add to Cart $ 132.30 1 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833630
Add to Cart $ 264.60 4 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833858
Add to Cart $ 423.36 8 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833860

Active Query Builder for .NET - Professional Subscription Renewal

Add to Cart $ 220.50 1 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833862
Add to Cart $ 441.00 4 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833866
Add to Cart $ 705.60 8 Developer Renewal (1 Year of Free Upgrades & Priority Support) Delivered via Download
Mfr. Part No: 2833868

Active Query Builder for .NET (v2.9) - Professional Upgrade

Add to Cart $ 294.00 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Upgrade from Standard WinForms Edition Delivered via Download
Mfr. Part No: 2993728

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What's new in the Active Query Builder .NET Edition version 2.9?

  • Ability to save queries as persistent reusable objects for using as views in the following queries is added to the Professional .NET Subcription.
  • Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide the new "Reusable Queries" snippet.
  • To save and load user queries, use import/export methods of the QueryBuilder.UserQueries object.
  • Advanced Expression Editor, SQL Text Editor and Criteria Builder controls are skinned correctly with the DevExpress controls UI in Professional .NET Subcription.
  • Database Schema Tree performance is improved.
  • SQL syntax improvements and changes:
    • Oracle: Support for SEARCH and CYCLE clauses in CTE subqueries is made.
    • RedShift: Loading of metadata using PostgreSQL syntax provider is fixed.
    • Vertica: Information about foreign keys can be extracted using native DB connection.
    • MS Access: The parser now accepts identifiers quoted with backticks and convert them to square brackets.
    • MS SQL Server: New MSSQL 2012 analytic functions are added.
    • MS SQL Server: OFFSET-FETCH clause is supported by Query Transformer.
    • MS SQL Server: IIF function and "WITHIN GROUP" clause are supported now.
    • MS SQL Server: Loading of foreign keys for SQL Server 2000 and earlier is fixed.
    • PostgreSQL: Parsing of ROW clause is speeded up.
    • PostgreSQL: Metadata loading is speeded up.

What's new in the Active Query Builder .NET Edition version 2.8?

  • Added support for Microsoft SQL Server 2014

What's new in the Active Query Builder .NET Edition version 2.7?

  • Search in the Database Schema Tree and Add Object Window has been added.
  • QueryTransformer: The new ExportToXML() and ImportFromXML() methods are added to allow serialization of transformations to XML.
  • The new MetadataLoadingOptions.DisableAutomaticMetadataLoading property allows you to disable automatic metadata loading on query parsing.
  • Virtual objects and fields are present in the Query Statistics among with real objects expanded from virtual objects.
  • Alternate names are added to the query structure XML (QueryBuilder.Query.StructureXML).
  • The new PaintDesignPaneToBitmap() method is added for exporting the design pane content to an image.

Common product information about Active Query Builder

  • Completely visual building of complex SQL queries.
  • MS-Access style and SQL Server style interface.
  • User-friendly interface with drag & drop support.
  • Powerful means of working with parameters.
  • Working in offline mode, storing metadata in XML files.
  • Delicate handling of user queries.
  • Sophisticated SQL parser.
  • SQL Server, Access, Oracle, MySQL and ANSI SQL/92 dialects support.
  • VistaDB desktop database support.
  • SQL Formatter.

Integration with C#, VB.NET and other VS2005 built applications is achieved by setting a few properties or adding a few lines of code.
The component may be integrated into your .NET 2.0 application with just a few lines of code. Unlike many other .NET query building solutions, Active Query Builder for .NET does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible.

Full access to internal query representation objects.
Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

ADO.NET and generic event driven driver.
We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we created the generic event-driven metadata provider. You can use it to provide metadata information from any data source. It's quite simple and has just a few events to implement. Using the generic event-driven metadata provider you can work disconnected providing all necessary metadata information by yourself. (Generic event-driven metadata provider will be available on release)

.NET 2.0 Windows Forms Visual Query Builder
Active Query Builder .NET WinForms Edition
is a visual query builder component suite that allows your end-users to build SQL queries via an intuitive visual interface. It's powerful API allows to parse complex SQL queries for programmatic analysis and modification.

Active Query Builder .NET Edition supports Visual Studio .NET 2005 and 2008, Windows.Forms environment. The component was successfully tested with .NET Frameworks 2.0, 3.0 and 3.5. Active Query Builder is tested with Delphi Prism for .NET; sample project is available.

NEW - Active Query Builder ASP.NET
Active Query Builder ASP.NET Edition
is designed for ASP.NET 2.0 environment, it provides native and easy way to embed visual query building functionality into your ASP.NET projects. Active Query Builder ASP.NET Edition is based on Active Query Builder .NET (Windows Forms) Edition. Utilizing the same powerful SQL parsing engine, it's end-user web interface has much in common with the ancestor.

With Active Query Builder ASP.NET Edition you can parse, analyze and get access to internal query representation objects at the server side. At the client side, it provides powerful and easy-to-use interface with ability to combine visual query building process with direct SQL text editing to build complex SQL queries for the most of popular SQL dialects.

The client side of Active Query Builder ASP.NET Edition is written in pure HTML+CSS to separate web page layout from the content for a quicker, efficient, and easier redesign. Built with standard jQuery framework, Active Query Builder ASP.NET Edition heavily utilizes AJAX technology to provide rich interactivity through the advent of asynchronous HTTP requests that do not require page refreshes to return responses from a server-side. Active Query Builder ASP.NET Edition takes extremely low amount of web traffic and achieves high throughput performance by minimizing all network packets (using light-weight libraries, code packing, on-the-fly compression and JSON data formatting).

Active Query Builder ASP.NET Edition supports Visual Studio .NET 2005-2010, ASP.NET 2.0+ environment. The component was successfully tested with .NET Frameworks 2.0, 3.0 and 3.5. It's compatible with all modern browsers including Internet Explorer 6.0 or higher, FireFox 2.0+, Safari 3.0+, Opera 9.0+, Chrome.


List of features of Active Query Builder .NET Edition.

Completely visual building of complex SQL queries

  • Visual building of sub-queries
  • Visual building of unions
  • Columns pane allowing to define grouping, sorting, and constructing criteria
  • Tree pane to browse and navigate query tree
  • Database objects tree pane to add objects to query
  • Forecast: Visual criteria constructing tool for Where and Having clauses - Not available in free edition

Powerful programming interface

  • Configuring the layout of generated SQL code
  • Retrieving the list of parameters found in the query - Not available in free edition
  • Retrieving extended information about parameters: datatype, related object, field and operator - Not available in free edition
  • Ability to work with metadata - Not available in free edition
  • Ability to build queries with objects from different databases - Not available in free edition
  • Pre-filtering of database objects to speed up metadata loading - Not available in free edition
  • Saving and loading all metadata information to XML format - Not available in free edition
  • Ability to work in offline mode - Not available in free edition
  • Full access to internal query representation objects - Not available in free edition

Support for various SQL Dialects

  • ANSI SQL/92
  • Microsoft SQL Server - Not available in free edition
  • Oracle - Not available in free edition
  • Microsoft Access - Not available in free edition
  • MySQL - Not available in free edition
  • Direct connect to VistaDB 3 - Not available in free edition

Several visual representation models

  • MS Access style
  • SQL Server Enterprise Manager style

Miscellaneous options

  • SQL Formatter: Plain text output filter to customize SQL code the way you like it

Full set of database connectivity options

  • OLE DB Metadata provider
  • MS SQL Server Metadata provider - Not available in free edition
  • Oracle Metadata provider (MS & Native) - Not available in free edition
  • MySQL Metadata provider - Not available in free edition
  • ODBC Metadata provider
  • Vista DB Metadata provider - Not available in free edition
  • Generic event-driven metadata provider

Support

Priority Support
The Premium Support Program was developed at the request of some of Active Database Software's current and potential customers who have their own support obligations to their end-users, so they have to be sure to receive answers in a timely manner. This program will ensure you receive answers from Active Database Software support staff within 24 hours (excluding weekends and holidays), to have your bug reports processed foremost, and your wishes and suggestions to be placed higher in their to-do list.

Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Screenshot Gallery

Click for full screen preview

Screenshot of Active Query Builder - .NET - v2.9 Screenshot of Active Query Builder - .NET - v2.9 Screenshot of Active Query Builder - .NET - v2.9 Screenshot of Active Query Builder - .NET - v2.9
Award