Looking for user-friendly query builder
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26257
Printed Date: 28 March 2026 at 9:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Looking for user-friendly query builder
Posted By: tigerw
Subject: Looking for user-friendly query builder
Date Posted: 15 September 2008 at 11:36am
|
Hi, We would like to provide the users of our intranet site with ability to build their own queries to underlain database. Could someone suggest an ASP.NET control which help to solve this task? I am looking for some user-friendly solution where I could hide all those database issues (tables, links, fields, etc) from end users but show them only the items that I want. For example I would like to hide Customer.CustNo field or show Customer.CityID as "Customer City" with list of available cities when user creates a condition with this field. |
Replies:
Posted By: ssmagin
Date Posted: 16 September 2008 at 10:31am
|
Hi, If you have nothing against ActiveX controls, you may try our SQL query building solution: http://www.activequerybuilder.com - Active Query Builder . Using it, you won't have to get direct access to the database, but provide all necessary metadata from the XML file. Using Active Query Builder you may assign user-friendly names for your database objects and their fields. |
Posted By: tigerw
Date Posted: 16 September 2008 at 2:39pm
|
Thank you for your proposition but I should say that your solution does not suit our requirements: 1. It is not pure ASP.NET solution. 2. It is not user-friendly. Or better say: your live demo does not show how friendly it is. In that demo I still need to define the tables which take part in the query - this is one of the things I would like to hide from my users. |
Posted By: tigerw
Date Posted: 16 September 2008 at 3:27pm
|
Finally we have found exactly what we need: http://devtools.korzh.com/eq/dotnet - EasyQuery.NET WebForms (thanks go Google). Here is the description of this library from the vendor's web-site: "EasyQuery.NET - native .NET components which allow to include user-friendly query builder into your Windows Forms application or ASP.NET web-site." They have setup demo page at http://www.easyquerydemo.com - http://www.easyquerydemo.com where you can play with EasyQuery.NET controls to see how they work. |
Posted By: ssmagin
Date Posted: 16 September 2008 at 3:49pm
|
Oh, sure. My best wishes to Korzh from Active Database Software 
|