Active Query Builder ASP.NET Edition History

December 08, 2010

Active Query Builder ASP.NET Edition v.0.4

+ Events to perform specific actions in response to user actions are added.
  See the list and description in details.
+ Query Properties dialogs are added for all supported syntaxes. They allow 
  user to change such properties as TOP, LIMIT, DISTINCT and many other.
+ Several demo projects are added to illustrate various aspects of the 
  component's functionality: Virtual Objects And Fields, Alternate Names,
  Interacting with ASP.NET controls, Hiding the Diagram Pane.
= The SqlEditor.SQL property now retrieves actual SQL query text with changes
  made by the user in the text editor.

See the full story for details

November 02, 2010

Active Query Builder ASP.NET Edition v.0.3.1

+ Ability to localize the component is made. Today the component is translated
  to all major European languages. The component determines language on the 
  client PC and loads it automatically if found. 
+ Ability to define language at design time is made. You may specify desired 
  language code using the QueryBuilderControl.Language property.
+ Ability to use custom localizations is made. Set the QueryBuilderControl.
  UseCustomLanguageFiles property to True to instruct the component to search
  for language files in the "Language Files" folder at the root of your web
  site instead of embedded language resources.

October 22, 2010

Active Query Builder ASP.NET Edition v.0.3

+ The new column is added to the Criteria Pane for moving and deleting rows.
+ The context menu is added to the Criteria Pane for moving and deleting rows.
+ The new autosync algorithm is implemented to avoid web page refreshing on
  changing/restarting of the server side.
+ Criteria pane is stretched to 100% width now.
+ Objects at design pane can be minimized now. 
+ Ability to define min/max size of objects is made.
- Object's aliases are quoted now if need.
= Overall performance imrovements are made.
- Several minor fixes for Internet Explorer are made.
- Fixed bug with simultaneous use of the AddLinkedObjects and
  DeleteUnusedObjects properties.

September 02, 2010

Active Query Builder ASP.NET Edition v.0.2.2

= Overall performance improvement in Internet Explorer is made.
= Expression and Sorting drop-down controls are improved.
- Fixed changing of the grid columns width on selecting a column for some
- Small CSS fixes for Internet Explorer 7 are made.

August 16, 2010

Active Query Builder ASP.NET Edition v.0.2.1

+ The canvas can be hidden now. Use the "visible" property on  
  control or just delete it from the web page. The new sample project 
  "no_design_area_demo" is added. In conjunction with the new properties of the 
  QueryBuilder component this allows you to build queries by dragging fields 
  from the database objects tree to the columns grid.
+ The new properties AddLinkedObjects and DeleteUnusedObjects are added to the
  QueryBuilder.LinkOptions group. The AddLinkedObjects instructs the 
  component to add necessary objects to join the newly added object with
  existing objects. For example, using the Northwind database, by adding Orders
  and Products tables to the query, the [Order Details] table will be added 
  automatically and joins will be set according to the foreign keys. 
  The DeleteUnusedObjects property instructs the component to remove objects
  from the query if their fields are not used in the query and these objects are
  no longer used to link other objects.
- Fixed bug with clearing a query text or removal of all tables from the canvas.
+ Compatibility with Microsoft Ajax Framework is made. Now the component can be 
  used with UpdatePanel.
- Fixed bug with link rendering and creation.
- Ability to change join types via the context menu is restored.
+ The jQuery library is upgraded from 1.7.2 to 1.8.3.

July 23, 2010

Active Query Builder ASP.NET Edition v.0.2.0

- Fixed various problems while working in Internet Explorer 7: database objects
  tree layout is corrected, links creation is possible now.
- Installer is adding component to the toolbox now.
- Other minor bugs are fixed.

July 19, 2010

Active Query Builder ASP.NET Edition v.0.1.9

+ Added warning on not loading required JavaScript files.
+ All QueryBuilder control parts are united within single ASCX control.
+ Automatic restore on loosing connection after timeout is made.
- Fixed the "Unspecified Error" in Internet Explorer.

July 15, 2010

Active Query Builder ASP.NET Edition v.0.1.8

+ Brief error reporting to the client is made. The new Message property is added
  to the QueryBuilderControl.
- Fixed visual bug with changing grid cell width during the editing.
- Fixed problem with Criteria cell updating.
- Minor JavaScript improvements for Internet Expolrer are made.

July 09, 2010

Active Query Builder ASP.NET Edition v.0.1.7

= The new property ShowFields is added to the ObjectTree control to show/hide
  fields in the tree ("false" by default). Setting this property to True will
  lead to slowing down of metadata loading process now. This effect will be
  eliminated in the near future.
- Fix bug with the asterisk checkbox in object's field lists.
- Fixed problem with positioning on dragging an object to the diagram pane.
- Grid functionality is restored.
- Other minor bugs are fixed.

July 07, 2010

Active Query Builder ASP.NET Edition v.0.1.6

= Data exchange protocol is improved: packet transfer is implemented for better
+ 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
+ Source code samples for Visual Studio 2005 are added.
- The bug with grid check boxes updating is fixed.
- The bug with recursive grid updates is fixed.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks