• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

SQL Query Builder


I am looking for a query builder tool which can be used in my .net application. The idea is I am trying to develop the .net application, which has a button on click of that, it has to open the query builder tool, on close of that tool, i want the bring that query from the sql builder tool to the .net application. Can anyone advise me the way of working the idea.

Thanks in advance,
2 Solutions
Mark WillsTopic AdvisorCommented:
Well, there is http://www.activequerybuilder.com/product.html which has source code available as well, but it is pretty much a full blown visual query editor and costs quite a bit...

Depends a bit on what you want to do and how much you want to spend...
Ryan McCauleyData and Analytics ManagerCommented:
By "Query builder", what functionality are you looking for - do you just want a textbox where they can type in some text, or are you looking for drag and drop tables/views, relationships, syntax highlighting, and intellisense? If it's the former, then just a textbox with an "Execute query" button should get it done, but if it's the latter, you'll probably want something along the lines of what Mark recommended, though it's pricey.

If we're missing the point of what you're asking, perhaps you can provide some context about what your query building (and application) are doing and why the functionality is necessary, and then we can make a more educated recommendation about functionality that meets your needs.
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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