Below is the list of fixes and improvements in 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.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
public event EventHandler Init; // This event is intended to perform initialization of the query builder object (QueryBuilderControl.QueryBuilder) // There you have to define metadata and syntax providers for the query builder. // Metadata provider is necessary when you're going to retrieve metadata from a database. // The alternate way to load metadata is to use pre-generated XML file (http://www.activedbsoft.com/helpdesk/index.php?pg=kb.page&id=1). // Syntax provider determines SQL syntax rules to build and parse queries. It can be set only in the full version of the component. // In the trial version syntax provider is already set to UniversalSyntaxProvider and this can't be changed. // See the Quick Start Guide to find example of this event handler: http://www.activequerybuilder.com/quick_start_guide.html#asp public event SqlErrorEvenHandler SQLError; // You may pass any SQL query text to the QueryBuilder.SQL property and have it parsed and represented visually in the control. // If the component fails to parse a query, it raises an exception. Alternate way to catch SQL parsing errors is to use this event. // Having the SQLError event handler defined, the component will not raise an exception in this case, but fire the event instead. public event EventHandler SQLUpdated; // This event is fired each time the SQL query text is updated, i.e. after successful parsing of the query // or after any user's actions with the control that lead to changing of the query text. public event CustomizeDatasourceCaptionEventHandler CustomizeDatasourceCaption; // This event allows you to customize the text that shown in the caption of a datasource at design pane. public event CustomizeDatasourceFieldListEventHandler CustomizeDatasourceFieldList; // This event allows you to customize list of fields for a datasource. // There you may sort fields within the list or remove unwanted fields from the list. public event DatasourceAddedEventHandler DatasourceAdded; // This event is fired when a new datasource (database object, derived table or CTE) is added to the query. // There you may define specific properties of the datasource (e.g. assign an alias) or // you may automatically add some fields from this datasource to the query (i.e. check them) or // you may establish a link to another datasource, etc. public event LinkCreatedEventhandler LinkCreated; // This event is fired when a new link is created in the query. // There you may set specific properties of the link (join type, expression, etc.) public event DatasourceFieldAddedEventHandler DatasourceFieldAdded; // This event is fired when a new field is added to the query columns list. // There you may set specific properties of this item (alias, sort order, etc.) public event DatasourceFieldRemovedEventHandler DatasourceFieldRemoved; // This event is fired after the field was removed from the query. public event QueryColumnListChangedHandler QueryColumnListItemChanged; // GridCellValueChanged in WinForms edition // This event is fired when the user performs some changes in the cells of the Query Column Grid Control, // i.e. the user changes properties of some Query Column List Item (alias, grouping, sorting or criteria).
You can always get the latest trial version of Active Query Builder ASP.NET Edition at the download page.
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!