QueryBuilder Class

QueryBuilder is the component to build SQL queries visually, to parse, analyze and modify SQL queries programmatically.

Object Model

Syntax

Visual Basic
C#
Managed Extensions for C++

'Declaration
 
Public Class QueryBuilder 
   Inherits System.Windows.Forms.UserControl

'Usage
 
Dim instance As QueryBuilder

public class QueryBuilder : System.Windows.Forms.UserControl

public __gc class QueryBuilder : public System.Windows.Forms.UserControl

Remarks

QueryBuilder requires a Syntax Provider to be assigned to the QueryBuilder.SyntaxProvider property. Metadata Provider assigned to the QueryBuilder.MetadataProvider property is necessary to load database schema information from database. Alternate way to load database schema is to use pre-generated XML files. See the MetadataContainer.ImportFromXML method for details. After that the InitializeDatabaseSchemaTree method should be called.

To get the result SQL query string, use the QueryBuilder.SQL property. Use the PlainTextSQLBuilder component to get the formatted SQL query text.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Windows.Forms.Control
            System.Windows.Forms.ScrollableControl
               System.Windows.Forms.ContainerControl
                  System.Windows.Forms.UserControl
                     ActiveDatabaseSoftware.ActiveQueryBuilder.QueryBuilder

Reference

QueryBuilder Members
ActiveDatabaseSoftware.ActiveQueryBuilder Namespace