Screenshot Preview

Active Query Builder for .NET - Resumen

de Active Database Software - Tipo de producto: Componente / ASP.NET WebForms / .NET WinForms / .NET Class / 100% Managed Code

Para su comodidad, hemos incluido enlaces a Google Translate para traducir la información del producto que todavía tenemos que traducir. Por favor, tenga en cuenta que traducciones automáticas no siempre son totalmente exactas.

 Con la tecnología de

Resumen

 *

Active Query Builder for .NET by Active Database Software

URLs: active-query-builder-net, active query builder net, activequerybuildernet, active-database, active database, activedatabase

Build complex SQL queries via an intuitive visual interface. Active Query Builder .NET Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder .NET Edition supports Visual Studio 2005, Windows.Forms environment (100% Managed Code, No direct Win32 interop calls). The new Active Query Builder ASP.NET Edition is designed for ASP.NET 2.0 environment, it provides native and easy way to embed visual query building functionality into your ASP.NET projects. Active Query Builder ASP.NET Edition is based on Active Query Builder .NET (Windows Forms) Edition. Utilizing the same powerful SQL parsing engine, it's end-user web interface has much in common with the ancestor.

Common product information about Active Query Builder

Completely visual building of complex SQL queries.

MS-Access style and SQL Server style interface.

User-friendly interface with drag & drop support.

Powerful means of working with parameters.

Working in offline mode, storing metadata in XML files.

Delicate handling of user queries.

Sophisticated SQL parser.

SQL Server, Access, Oracle, MySQL and ANSI SQL/92 dialects support.

VistaDB desktop database support.

SQL Formatter.

Integration with C#, VB.NET and other VS2005 built applications is achieved by setting a few properties or adding a few lines of code.

The component may be integrated into your .NET 2.0 application with just a few lines of code. Unlike many other .NET query building solutions, Active Query Builder for .NET does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible.

Full access to internal query representation objects.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

ADO.NET and generic event driven driver.

We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we created the generic event-driven metadata provider. You can use it to provide metadata information from any data source. It's quite simple and has just a few events to implement. Using the generic event-driven metadata provider you can work disconnected providing all necessary metadata information by yourself. (Generic event-driven metadata provider will be available on release)

.NET 2.0 Windows Forms Visual Query Builder

Active Query Builder .NET WinForms Edition is a visual query builder component suite that allows your end-users to build SQL queries via an intuitive visual interface. It's powerful API allows to parse complex SQL queries for programmatic analysis and modification.

Active Query Builder .NET Edition supports Visual Studio .NET 2005 and 2008, Windows.Forms environment. The component was successfully tested with .NET Frameworks 2.0, 3.0 and 3.5. Active Query Builder is tested with Delphi Prism for .NET; sample project is available.

NEW - Active Query Builder ASP.NET

Active Query Builder ASP.NET Edition is designed for ASP.NET 2.0 environment, it provides native and easy way to embed visual query building functionality into your ASP.NET projects. Active Query Builder ASP.NET Edition is based on Active Query Builder .NET (Windows Forms) Edition. Utilizing the same powerful SQL parsing engine, it's end-user web interface has much in common with the ancestor.

With Active Query Builder ASP.NET Edition you can parse, analyze and get access to internal query representation objects at the server side. At the client side, it provides powerful and easy-to-use interface with ability to combine visual query building process with direct SQL text editing to build complex SQL queries for the most of popular SQL dialects.

The client side of Active Query Builder ASP.NET Edition is written in pure HTML+CSS to separate web page layout from the content for a quicker, efficient, and easier redesign. Built with standard jQuery framework, Active Query Builder ASP.NET Edition heavily utilizes AJAX technology to provide rich interactivity through the advent of asynchronous HTTP requests that do not require page refreshes to return responses from a server-side. Active Query Builder ASP.NET Edition takes extremely low amount of web traffic and achieves high throughput performance by minimizing all network packets (using light-weight libraries, code packing, on-the-fly compression and JSON data formatting).

Active Query Builder ASP.NET Edition supports Visual Studio .NET 2005-2010, ASP.NET 2.0+ environment. The component was successfully tested with .NET Frameworks 2.0, 3.0 and 3.5. It's compatible with all modern browsers including Internet Explorer 6.0 or higher, FireFox 2.0+, Safari 3.0+, Opera 9.0+, Chrome.

List of features of Active Query Builder .NET Edition.

Completely visual building of complex SQL queries

Visual building of sub-queries

Visual building of unions

Columns pane allowing to define grouping, sorting, and constructing criteria

Tree pane to browse and navigate query tree

Database objects tree pane to add objects to query

Forecast: Visual criteria constructing tool for Where and Having clauses - Not available in free edition

Powerful programming interface

Configuring the layout of generated SQL code

Retrieving the list of parameters found in the query - Not available in free edition

Retrieving extended information about parameters: datatype, related object, field and operator - Not available in free edition

Ability to work with metadata - Not available in free edition

Ability to build queries with objects from different databases - Not available in free edition

Pre-filtering of database objects to speed up metadata loading - Not available in free edition

Saving and loading all metadata information to XML format - Not available in free edition

Ability to work in offline mode - Not available in free edition

Full access to internal query representation objects - Not available in free edition

Support for various SQL Dialects

ANSI SQL/92

Microsoft SQL Server - Not available in free edition

Oracle - Not available in free edition

Microsoft Access - Not available in free edition

MySQL - Not available in free edition

Direct connect to VistaDB 3 - Not available in free edition

Several visual representation models

MS Access style

SQL Server Enterprise Manager style

Miscellaneous options

SQL Formatter: Plain text output filter to customize SQL code the way you like it

Full set of database connectivity options

OLE DB Metadata provider

MS SQL Server Metadata provider - Not available in free edition

Oracle Metadata provider (MS & Native) - Not available in free edition

MySQL Metadata provider - Not available in free edition

ODBC Metadata provider

Vista DB Metadata provider - Not available in free edition

Generic event-driven metadata provider

What's new in the Active Query Builder .NET Edition version 2.9?

Ability to save queries as persistent reusable objects for using as views in the following queries is added to the Professional .NET Subcription.

Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide the new "Reusable Queries" snippet.

To save and load user queries, use import/export methods of the QueryBuilder.UserQueries object.

Advanced Expression Editor, SQL Text Editor and Criteria Builder controls are skinned correctly with the DevExpress controls UI in Professional .NET Subcription.

Database Schema Tree performance is improved.

SQL syntax improvements and changes:

Oracle: Support for SEARCH and CYCLE clauses in CTE subqueries is made.

RedShift: Loading of metadata using PostgreSQL syntax provider is fixed.

Vertica: Information about foreign keys can be extracted using native DB connection.

MS Access: The parser now accepts identifiers quoted with backticks and convert them to square brackets.

MS SQL Server: New MSSQL 2012 analytic functions are added.

MS SQL Server: OFFSET-FETCH clause is supported by Query Transformer.

MS SQL Server: IIF function and "WITHIN GROUP" clause are supported now.

MS SQL Server: Loading of foreign keys for SQL Server 2000 and earlier is fixed.

PostgreSQL: Parsing of ROW clause is speeded up.

PostgreSQL: Metadata loading is speeded up.

What's new in the Active Query Builder .NET Edition version 2.8?

Added support for Microsoft SQL Server 2014

What's new in the Active Query Builder .NET Edition version 2.7?

Search in the Database Schema Tree and Add Object Window has been added.

QueryTransformer: The new ExportToXML() and ImportFromXML() methods are added to allow serialization of transformations to XML.

The new MetadataLoadingOptions.DisableAutomaticMetadataLoading property allows you to disable automatic metadata loading on query parsing.

Virtual objects and fields are present in the Query Statistics among with real objects expanded from virtual objects.

Alternate names are added to the query structure XML (QueryBuilder.Query.StructureXML).

The new PaintDesignPaneToBitmap() method is added for exporting the design pane content to an image.

Build complex SQL queries via an intuitive visual interface.

Pricing: Active Query Builder for .NET (v2.9) - Standard WinForms Subscription 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Standard WinForms Subscription 1 Developer License, price per license for 2 Developers (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Standard WinForms Subscription 1 Developer License, price per license for 3 Developers (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Standard WinForms Subscription 4 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Standard WinForms Subscription 8 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.7) - Standard ASP.NET Subscription 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.7) - Standard ASP.NET Subscription 1 Developer License, price per license for 2 Developers (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.7) - Standard ASP.NET Subscription 1 Developer License, price per license for 3 Developers (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.7) - Standard ASP.NET Subscription 4 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.7) - Standard ASP.NET Subscription 8 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Subscription 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Subscription 1 Developer License, price per license for 2 Developers (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Subscription 1 Developer License, price per license for 3 Developers (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Subscription 4 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Subscription 8 Developer License (Includes 1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Subscription Full Source Code (Requires Professional Developer License), Active Query Builder for .NET - Standard WinForms Subscription Renewal 1 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Standard WinForms Subscription Renewal 4 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Standard WinForms Subscription Renewal 8 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Standard ASP.NET Subscription Renewal 1 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Standard ASP.NET Subscription Renewal 4 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Standard ASP.NET Subscription Renewal 8 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Professional Subscription Renewal 1 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Professional Subscription Renewal 4 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET - Professional Subscription Renewal 8 Developer Renewal (1 Year of Free Upgrades & Priority Support), Active Query Builder for .NET (v2.9) - Professional Upgrade 1 Developer License (Includes 1 Year of Free Upgrades & Priority Support) Upgrade from Standard WinForms Edition

Evals & Downloads: Read the Active Query Builder User Guide, Read the Active Query Builder .NET Edition help file, Read the Active Query Builder DataSheet, Download the Active Query Builder .NET WinForms Edition v2.7 evaluation on to your computer - Limited Functionality, Download the Active Query Builder ASP.NET Edition v2.2 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows NT 4.0

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: ASP.NET WebForms, .NET WinForms, .NET Class, 100% Managed Code

Compatible Containers: Microsoft Visual Studio 2013, Microsoft Visual Studio 2012, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2013, Microsoft Visual Basic 2012, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2013, Microsoft Visual C++ 2012, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2013, Microsoft Visual C# 2012, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft SQL Server 2014, Microsoft Internet Explorer 11, Microsoft Internet Explorer 10.0, Microsoft Internet Explorer 9.0, Microsoft Internet Explorer 8.0, Microsoft Internet Explorer 7.0, Microsoft Internet Explorer 6.0, Mozilla Firefox 21, Mozilla Firefox 20, Mozilla Firefox 19, Mozilla Firefox 18, Mozilla Firefox 17, Mozilla Firefox 16, Mozilla Firefox 15, Mozilla Firefox 14, Mozilla Firefox 13, Mozilla Firefox 12, Mozilla Firefox 11, Mozilla Firefox 10, Mozilla Firefox 9, Mozilla Firefox 8, Mozilla Firefox 7, Mozilla Firefox 6, Mozilla Firefox 5, Mozilla Firefox 4, Mozilla Firefox 3.6, Mozilla Firefox 3.5, Mozilla Firefox 3.0, Mozilla Firefox 2.0, .NET Framework 4.5, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Keywords: SQL, query, activequery, active query builder, querybuilder, active query builder, sql query, sql queries

SQL query language

Part numbers: PC-516519-770274 516519-770274 PC-516519-770313 516519-770313 PC-516519-770314 516519-770314 PC-516519-770276 516519-770276 PC-516519-770278 516519-770278 PC-516519-770280 516519-770280 PC-516519-770315 516519-770315 PC-516519-770316 516519-770316 PC-516519-770282 516519-770282 PC-516519-770284 516519-770284 PC-516519-770286 516519-770286 PC-516519-770317 516519-770317 PC-516519-770318 516519-770318 PC-516519-770288 516519-770288 PC-516519-770290 516519-770290 PC-516519-770292 516519-770292 PC-516519-770294 516519-770294 PC-516519-770296 516519-770296 PC-516519-770298 516519-770298 PC-516519-770300 516519-770300 PC-516519-770302 516519-770302 PC-516519-770304 516519-770304 PC-516519-770306 516519-770306 PC-516519-770308 516519-770308 PC-516519-770310 516519-770310 PC-516519-770312 516519-770312

Mfr. Part No: 2833506 2833630 2833854 2833856 2833858 2833860 2833862 2833866 2833868 2833870 2993728

Búsqueda de productos

Escriba palabras de búsqueda:

Enlaces

Autor

Categoría principal

Productos relacionados

La Tienda de Software para Profesionales de IT‎

Como distribuidores oficiales, ComponentSource ofrece cómodas compras centralizadas de más de 250 editores de software especializados en desarrollo de aplicaciones y operaciones.

Más Información | Sobre Nosotros

Galería de capturas de pantalla

Haga clic para obtener una vista previa completa

Captura de pantalla Active Query Builder - .NET - v2.9 Captura de pantalla Active Query Builder - .NET - v2.9 Captura de pantalla Active Query Builder - .NET - v2.9 Captura de pantalla Active Query Builder - .NET - v2.9
Award