Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Custom queries using a web GUI

HI

I have seen a software in a workstation that is capable of showing queries from a database and you can "customize" the appereance just using drag and drop over the field headers. I would like to know if this functionallity is available for web using a component or stuff like that.

But I´ll explain better all this, lets say that we have the following query:

ID_PRODUCT, CATEGORY, GROUP, ITEM, DESCRIPTION, PRICE

Just by dragging the header of the field CATEGORY to the grouping area (at the very top of the GUI), I could group all the registers by its Group content, I could even nest two or more headers in order to get a more sophisticated query.

This is a very powerful tool for watching the same info organized in different ways.
0
dimensionav
Asked:
dimensionav
2 Solutions
 
PaulHewsCommented:
I don't know of any straight ASP.NET components, as this kind of processing is pretty complex for client side work.  However, Infragistics has a brilliant Silverlight control called a pivot grid that does allow you to drag and drop filters and items.

http://samples.infragistics.com/sldv/ComponentOverview.aspx?cn=pivot-grid

0
 
CodeCruiserCommented:
I use DevExpress and they provide this function in their Winforms Grid component.

Looks like their grid for ASP.NET also supports it

http://documentation.devexpress.com/#AspNet/CustomDocument3715
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now