Easy QueryBuilder - A User-Friendly Ad-Hoc Advanced Search Solution: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Easy QueryBuilder - A User-Friendly Ad-Hoc Advanced Search Solution

page 1 of 3

Published: 13 Apr 2010

Unedited - Community Contributed

Abstract
Constructing an easy and powerful QueryBuilder interface becomes more important for complex data grid filtering and accurate reporting services. In this article, I'll discuss how to build a query search engine using ASP.NET AJAX and dynamic SQL. The main goal is to provide an interactive interface to allow users select query attributes, operators, attribute values, and T-SQL operators so that the data context query list can be easily composed and a search engine is invoked.

by Bing Wang
Feedback

Average Rating:

Views (Total / Last 10 Days): 18230/ 40

Article Contents:

Introduction

One of the projects that I have been working on was to provide a user interface to manage corporate security information such as personnel, Platform, LoginID, etc. I have designed and implemented a smart data search engine to filter various data based on queries from users. QueryBuilder was the choice for this design. To share the ideas with the ASP.NET community, the web form and major code snippets are listed below.