Active Query Builder

July 23, 2010

Active Query Builder ASP.NET Edition 0.2 Beta is released.

We're glad to announce the new version of Active Query Builder ASP.NET Edition. You can download the newest version or request the trial at the download page.

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

  • All QueryBuilder control parts are united within single ASCX control.
  • Metadata tree now shows table fields. You can drag fields from the tree and drop them right on the diagram pane or criteria grid, corresponding table will be automatically added on the diagram pane and the field will be selected.
  • The new property ShowFields is added to the ObjectTree control to show/hide fields in the tree.
  • Data exchange protocol is improved: packet transfer is implemented for better performance.
  • Automatic restore on loosing connection after timeout is made.
  • Usage samples for Visual Studio 2005 are added.
  • Now all Debug/Warning/Error messages will be collected in one [Log.txt] file (stored in website root folder). Please send us this file in case of any server or client-side errors.

Please note that there were many changes in the component during the past few weeks, so please review the updated demo projects and read the Quick Start Guide if you're upgrading from some older version.

» All Active Query Builder news

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.
CodeGear - Where Developers Matter

Screenshots

Multiple joins

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Join Types

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Criteria pane

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.


More Screenshots