Active Query Builder ASP.NET Edition

ASP.NET 2.0 Visual Query Builder component

Active Query Builder ASP.NET Edition is designed for ASP.NET 2.0 and higher environments, 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 live demo is available at http://aspquerybuilder.net/.

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.x and 4.0. It's compatible with all modern browsers including Internet Explorer 6.0 or higher, FireFox 2.0+, Safari 3.0+, Opera 9.0+, Chrome.

• Common product information about Active Query Builder
  
  • Easy visual building of complex SQL queries with unions and sub-queries.
  • MS-Access style user-friendly interface with drag & drop support.
  • Two-way SQL query building (combined with SQL text editing).
  • Defining user-friendly aliases for tables and field names.
  • Powerful means of SQL query analysis and programming modification.
  • Working in offline mode, storing metadata in XML files.
  • Restricting access to unwanted objects, preventing query execution.
  • Sophisticated SQL parser, support of most popular database servers.
  • SQL query text formatting.
  • Ability to localize the component
• SQL parser with full access to internal query representation objects.

  Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects tree that represents all parts of the SQL query. You can edit existing queries or create new SQL queries using these objects in run-time. (See the Non-visual and Query Modification demo projects that included in the Trial version)

• ADO.NET and custom metadata providers.

  We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we provided the other ways to load metadata to the query builder from any data source. Using them you can work disconnected providing all necessary metadata information by yourself. (You may learn more about different ways to load metadata at the Load Metadata demo project that included in the Trial version)

• Take a look at the full list of features of Active Query Builder ASP.NET Edition.

• ASP.NET Query Builder. Feature Matrix
• ASP.NET Query Builder. Reasons to use
• ASP.NET Query Builder. Live Demo
• ASP.NET Query Builder. Download
• ASP.NET Query Builder. Purchase