ComponentOne Query™ 8.0 is an elegant solution for ad hoc querying. Query collects end-user input and generates a SQL query or an ADO Filter condition at run time. You can add ad hoc query functionality to your apps and make it directly available to end-users, instead of preparing all imaginable queries beforehand at design time.

Features

Show All
  • Directly Available Ad Hoc Querying

    Query shields end-users from the complexities of database structure. End-users can construct their queries using convenient names and business concepts that they already know. Your end-users don't require any special skills in order to use Query in an application or need to be aware that the component was used to create the application.

  • Easy-to-use, Built-in Interface

    Query provides a built-in user interface that makes implementing ad hoc functionality as easy as dropping two controls on a form. You can use the interface as is, or readily customize it using templates and other easy-to-use options. You are no longer forced to use an interface that doesn't suit your needs!

  • Powerful Query Generation Engine

    Query contains a powerful query generation engine that supports queries spanning multiple tables. This means that you can create schemas exposing database fields to your users in a customized form by specifying relationships between tables.

  • SQL Database Support

    SQL queries generated by Query can run in every database supporting SQL. You can execute them using any database access engine available in Microsoft Windows: ADO/OLEDB, DAO, ODBC, and native database interfaces. You can customize the resulting SQL syntax, adjusting it to your database requirements.

  • Simple DataSource Mode

    If your queries don’t span multiple tables (a common case in many applications), using Query becomes a matter of "point and click." It can be bound to any ADO/OLE DB data source, just like any data-aware control, and will instantly be able to receive user input and generate queries without using the Schema Designer.

  • Hierarchical Folder Structure

    The built-in user interface exposes fields to your end-users in the form of a hierarchical folder structure. This enables you to name and organize query fields according to the customer business domain, rather than deal with database table and column names.

  • Lookup Lists

    You can specify "lookup data source" for a field and Query will present end-users with a lookup combo or menu (for example, users can select a product from a list of products, instead of entering a cryptic ID). Adding a lookup is as easy as calling a method specifying the data source and the names of the fields in the lookup. And it's fully customizable - you can create fixed lookup lists in schema or you can retrieve them from a database or fill them programmatically in a special event.

  • Custom Editors

    You can use the default edit and lookup facilities included with Query or you can specify any ActiveX control as an editor for a constant value in a query. This way, you can implement custom editing and custom lookup.

  • Multi-table Views

    You can create multi-table views combining information stored in different tables with the Schema Designer.

  • Calculated Fields

    Calculated fields can be added to schema views so that users can query these fields as if they were stored in the database.

As a leading component vendor in the Microsoft Visual Studio Industry Partner program, ComponentOne has been providing the widest range of Microsoft Visual Studio components, IDE platform development tools, and applications for over 22 years. ComponentOne product lines encompass custom WinForms, ASP.NET, WPF, Silverlight, Mobile, and COM components, documentation tools, and Web Parts for Microsoft Office SharePoint Server and Windows SharePoint Services.

Contact ComponentOne: 1.800.858.2739 | Pittsburgh: 412.681.4343

©2012 ComponentOne LLC All Rights Reserved.
All product and company names herein may be trademarks of their respective owners.
ComponentOne holds a license under Patent No. 5,490,216 (which expires on September 21, 2013)

ComponentOne