Click here to Skip to main content
15,039,244 members
Articles / Database Development / SQL Server
Article
Posted 1 Feb 2005

Stats

357.6K views
315 bookmarked

QueryCommander SQL Editor

Rate me:
Please Sign up or sign in to vote.
4.90/5 (69 votes)
27 Sep 20053 min read
QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.

Sample Talbe IntelleSense

Sample Column IntelliSense

Sample Talbe IntelleSense

Sample Column IntelliSense

Introduction

With version 4.0 of QueryCommander comes loads of new or improved features such as:

  • Much improved VSS support.
  • Test bench for testing scripts and database objects.
  • Implemented “edit-in-grid” for Oracle.
  • Encrypted password.
  • Extended objects in Server Explorer (table fields, triggers and UDTs to the server browser etc.).
  • Print functionality (output or statement).
  • Abort running query.
  • Documentation Header enhancements.
  • Query builder for creating statement by drag and drop of fields into a Query window.
  • Extended database support for Firebird and DB2.
  • Customized tab size setting.
  • The IntelliSense is extended to give the user information about all possible joins between tables in a statement.
  • Filter option on creating documentation file.
  • Save before close window.
  • New plug-ins for saving result as XML and for saving result as an Excel file.
  • And much, much more.

For those who yet haven't used QueryCommander, it is basically a SQL editor in a modern developer environment with IntelliSense and many useful features to help in the day to day work with databases. It is not the complete database administration tool. If you really need to dig down the fundamentals, you should use Microsoft Query Analyzer, Toad etc. However, if you need a good tool to rapidly create queries, stored procedures, user defined functions etc., we hope QueryCommander will be your alternative.

QueryCommander supports:

  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2000
  • Microsoft SQL Server 6.5
  • MySQL 4.x
  • Oracle 9i
  • Firebird
  • DB2

Background

The application has been developed since May 2003. Its primary goal is to bring a more modern environment to the developers working with databases. It started out with a handful of features such as IntelliSense, unified comment header generator etc. But as the application spread to more users, the demands for more features grew. The project has been hosted on the SourceForge where many developers and users have helped in the evolution of this application. The requests for more features have been greater than ever. This is the main reason why the future of this project is best served under the OpenSource "umbrella".

Using the code

Since the code is subject to changes, please visit the SouceForge site for downloading the code.

GUI Framework

Weinfen Luo has been kind enough to provide us with the Visual Studio layout and design. This means we have a MDI form (MainForm.cs) and some child forms (FrmQuery, FrmOutput, FrmDBObjects etc...). In order for this to work, the child window inherits from WeinfenLuo.WinFormsUI.DockContent. All other windows are "pop-up"-dialogs (FrmGotoLine, FrmSearch, FrmXMLErrors etc.).

Query Window

The Editor dialog (FrmQuery) initiates most of the public logic within this application. Each Query dialog has its own database connection object.

The Editor

This has been the biggest challenge while developing the QueryCommander, until the guys at SharpDevelop released their ICSharpCode.TextEditor. It took some minor adjustments in order to make the highlighting work with the SQL language.

Database

QueryCommander supports five different data providers, each data provider has its own Data Manager which inherits from IDatabaseManager. A Data Manager comes with a set of predefined queries used for IntelliSense etc. These queries are found in \Meta\QueryString.xml.

Credits and thankfulness

  • Weifen Luo - DockPanel Suite is designed to achieve docking capability for MDI forms. It can be used to develop Visual Studio .NET style applications.
  • #develop - SharpDevelop is an open source IDE for the .NET platform. QueryCommander is using their ICSharpCode.TextEditor.
  • Rockwolf - For hosting the development of QueryCommander.
  • Aprenot - Reusable Diff Algorithm in C#.
  • Rama Krishna Kolluri - C# class library for exporting data to CSV/Excel file.
  • Franz Ehrenhuber - For testing, help and input.
  • Frans Nylin - For helping out with the Oracle implementation.
  • Lindsey Lewis - For developing, help and input.
  • Christian Halvarsson and Farid Benhajji - For helping out with the web layout.

For more information

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Mikael Håkansson
Web Developer
Sweden Sweden
No Biography provided

Comments and Discussions

 
GeneralApplication crashes on replace Pin
Vertyg027-Sep-05 10:06
MemberVertyg027-Sep-05 10:06 
GeneralRe: Application crashes on replace Pin
Mikael Håkansson27-Sep-05 19:32
MemberMikael Håkansson27-Sep-05 19:32 
GeneralRe: Application crashes on replace Pin
Vertyg027-Sep-05 22:15
MemberVertyg027-Sep-05 22:15 
GeneralRe: Application crashes on replace Pin
Mikael Håkansson27-Sep-05 22:17
MemberMikael Håkansson27-Sep-05 22:17 
GeneralRe: Application crashes on replace Pin
Vertyg028-Sep-05 2:36
MemberVertyg028-Sep-05 2:36 
GeneralScreen "real estate" and other suggestions Pin
Tony J. Vites9-Aug-05 3:13
sussTony J. Vites9-Aug-05 3:13 
GeneralRe: Screen "real estate" and other suggestions Pin
Mikael Håkansson9-Aug-05 5:38
MemberMikael Håkansson9-Aug-05 5:38 
GeneralRe: Screen "real estate" and other suggestions Pin
Lindsey Lewis28-Sep-05 4:50
MemberLindsey Lewis28-Sep-05 4:50 
FYI, TOAD is no longer free. A company by the name of Quest Software now sells it. They do have a MS SQL Beta version which does not support source control where as the new version of Query Commander does;).

The highest sounds are hardest to hear.
Going forward is a way to retreat.
Great talent shows itself late in life.
Even a perfect program still has bugs.
GeneralSetup For MySQL Pin
Paul Conrad30-Jul-05 6:27
professionalPaul Conrad30-Jul-05 6:27 
GeneralRe: Setup For MySQL Pin
Mikael Håkansson31-Jul-05 12:47
MemberMikael Håkansson31-Jul-05 12:47 
GeneralRe: Setup For MySQL Pin
Paul Conrad31-Jul-05 13:28
professionalPaul Conrad31-Jul-05 13:28 
Generala shame that you're do not continue with developing this tool Pin
DaberElay23-Jul-05 20:09
MemberDaberElay23-Jul-05 20:09 
GeneralSite *is* up, must have been down when you tried it Pin
Member 9628-Jul-05 4:15
MemberMember 9628-Jul-05 4:15 
GeneralRe: a shame that you're do not continue with developing this tool Pin
Mikael Håkansson31-Jul-05 12:43
MemberMikael Håkansson31-Jul-05 12:43 
QuestionI can NOT dpwnload files? Pin
Behzad Ebrahimi14-May-05 22:19
MemberBehzad Ebrahimi14-May-05 22:19 
General@Firebird support Pin
Mikael Håkansson18-Apr-05 0:29
MemberMikael Håkansson18-Apr-05 0:29 
GeneralRe: @Firebird support Pin
Member 9628-Jul-05 4:17
MemberMember 9628-Jul-05 4:17 
QuestionMiss sybdrvado11.dll? Pin
coldautumn27-Feb-05 0:49
Membercoldautumn27-Feb-05 0:49 
AnswerRe: Miss sybdrvado11.dll? Pin
Mikael Håkansson27-Feb-05 4:18
MemberMikael Håkansson27-Feb-05 4:18 
GeneralRe: Miss sybdrvado11.dll? Pin
coldautumn27-Feb-05 13:41
Membercoldautumn27-Feb-05 13:41 
GeneralRe: Miss sybdrvado11.dll? Pin
Mikael Håkansson2-Mar-05 20:19
MemberMikael Håkansson2-Mar-05 20:19 
GeneralRe: Miss sybdrvado11.dll? Pin
coldautumn4-Mar-05 13:22
Membercoldautumn4-Mar-05 13:22 
GeneralRe: Miss sybdrvado11.dll? Pin
coldautumn4-Mar-05 13:24
Membercoldautumn4-Mar-05 13:24 
AnswerRe: Miss sybdrvado11.dll? Pin
Mikael Håkansson23-Mar-05 6:48
MemberMikael Håkansson23-Mar-05 6:48 
GeneralRe: Miss sybdrvado11.dll? Pin
coldautumn30-Mar-05 20:25
Membercoldautumn30-Mar-05 20:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.