Welcome, Guest
Open an Account | Sign In

ComponentOne Query

Download Buy Now
ComponentOne Query

End-user Ad Hoc Query Builder

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

Part of ComponentOne Studio® EnterprisePart of ComponentOne Studio® for ActiveX

Controls Included

  • C1Query
  • C1QueryFrame
  • C1QueryUI

Get Started!

ComponentOne Query Features

  • Directly Available Ad Hoc Querying

    ComponentOne 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 ComponentOne Query in an application or need to be aware that the component was used to create the application.

  • Easy-to-use, Built-in Interface

    ComponentOne 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

    ComponentOne 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 ComponentOne 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 ComponentOne 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 ComponentOne 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 ComponentOne 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.

ComponentOne product lines encompass a diverse range of high-quality, cutting-edge tools and solutions enabling users to successfully build powerful, robust applications. ComponentOne is the premier provider of a diverse set of .NET, ASP.NET, WPF, Silverlight, Mobile, and COM components focused on accelerating visual development with drag-and-drop tools that simplify the design-time experience and extend the power of Microsoft Visual Studio.

Home | Download Free Trial | Support | Company | Software Renewals | Store | Privacy | Terms of Use
Studio Enterprise | .NET WinForms Components | ASP.NET WebForms Components | WPF Components | Help Authoring Tools

All product and company names herein may be trademarks of their respective owners.

Contact ComponentOne: 1.800.858.2739 | UK: +44(0)1460 234636

©1987-2008 ComponentOne LLC All Rights Reserved.