Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
Can anyone please recommend an off the shelf (free or paid for) control (C# WinForms) that will give users drag and drop functionality to query data from any SQL database.

This purpose of this is for general segmentation. For example, a user might want to get a list of accounts that has been active in the last 90 days and has spent between $100 and $200 in total.

These users do not necessarily understand SQL, and more to the point, table joins, group by and aggregation functions.

I've been looking at using a Cube and the DevExpress pivotgrid: https://www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/

The biggest problem I am experiencing is that The control cant give me an MDX query so that I can re-run the query later. Which also means I cant later give the control an MDX query so that a user may update it.

Telerek's pivotgrid has the same problem.

Also looked at Korzh EasyQuery.Net: http://devtools.korzh.com/easyquery/

My issue here is that you have to define a data model in the form of a xml file beforehand, so if the underlying schema changes, we have to generate a new data model and deploy that. This also doesn't support aggregations very nicely, you have to specify what you would like to aggregate beforehand when generating the data model.

I need to be able to point this control to any database at run-time, and it should be able to work out the available columns etc. by itself.

Any other suggestions?
Posted
Comments
RedDk 11-Feb-15 1:42am    
Off the shelf controls are used by developers who wish to drop functionality into their applications. A "control", in this respect, actually doesn't mean anything to a user. So, non-technical users ... are just regular users?

I give up trying to understand what you mean in the rest of the elaboration. But here's a link to an article here on CP:

http://www.codeproject.com/Articles/33433/SQL-Server-CE-Query-Tool?fid=1535134&tid=4014539

Take a look at the "control"(s) in THIS application. There's a treeview, there's a textbox, etc. Repost question if anything here rings a bell.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900