Active Query Builder

June 11, 2010

The new SQL Text Editor and Expression Editor for .NET is available now.

We are glad to announce the new component for Windows.Forms .NET 2.0 Framework intended for fast and convenient SQL text editing. The component requires Active Query Builder .NET Edition to perform SQL parsing and to get access to metadata information and SQL dialect settings of a database.

Key features:

• Easy access to the list of database server keywords, operators and functions
• Easy access to the database schema information
• Code completion and context-sensitive suggestion lists
• SQL syntax highlighting

The component can be used as a standalone SQL Text Editor (Active Query Builder can be visible or hidden, but it's needed anyway) or as an Expression Editor for Active Query Builder that accessible through the ellipsis button of Expression and Criteria column cells.

To use the component as a standalone SQL Text Editor, you should drag the SQLTextEditor component from the toolbox to a form and set the SQLTextEditor.QueryBuilder property to an instance of the QueryBuilder component. To use the component as an Expression Editor, you should drag the ExpressionEditor component from the toolbox to a form and set the QueryBuilder.ExpressionBuilder property to an instance of ExpressionEditor. You may find the sample project that illustrates working with the component included in the Trial version.

Please note that SQL Text Editor is available as a part of .NET Professional Subscription only.

» All Active Query Builder news