Click here to Skip to main content
11,928,078 members (49,231 online)
Click here to Skip to main content
Add your own
alternative version


304 bookmarked

QueryCommander SQL Editor

, 27 Sep 2005
Rate this:
Please Sign up or sign in to vote.
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


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


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.


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


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


About the Author

Mikael Håkansson
Web Developer
Sweden Sweden
No Biography provided

You may also be interested in...

Comments and Discussions

Bugis dead? Pin
Member 458010525-May-14 22:38
memberMember 458010525-May-14 22:38 
Questionupdates Pin
kiquenet.com12-Jun-13 22:11
memberkiquenet.com12-Jun-13 22:11 
GeneralMy vote of 5 Pin
Abinash Bishoyi5-Mar-13 7:44
memberAbinash Bishoyi5-Mar-13 7:44 
GeneralMy vote of 5 Pin
Kanasz Robert25-Sep-12 23:52
mvpKanasz Robert25-Sep-12 23:52 
QuestionAdding stored procedures to Drag and Drop Pin
stain35653-Nov-11 3:50
memberstain35653-Nov-11 3:50 
GeneralDocking panels - preventing dragging Pin
stain356517-Jun-11 1:39
memberstain356517-Jun-11 1:39 
Questionany updates for sql server 2008 an oracle 10i ?? Pin
alhambra-eidos27-Dec-10 1:49
memberalhambra-eidos27-Dec-10 1:49 
GeneralA great application Pin
zhoufoxcn13-May-10 22:35
memberzhoufoxcn13-May-10 22:35 
GeneralMissing "normally expected" features Pin
Pandele Florin29-Sep-09 8:26
memberPandele Florin29-Sep-09 8:26 
QuestionSupport Oracle 10g ? Pin
alhambra-eidos22-May-09 0:14
memberalhambra-eidos22-May-09 0:14 
QuestionQueryCommander SQL Editor License Pin
irinabe20-Jan-09 1:27
memberirinabe20-Jan-09 1:27 
AnswerRe: QueryCommander SQL Editor License Pin
john_17265-Mar-10 10:51
memberjohn_17265-Mar-10 10:51 
GeneralI couldnt get it to work Pin
uofakron13-Nov-07 10:26
memberuofakron13-Nov-07 10:26 
GeneralSybase Support Pin
memberC.DHAKCHINA MOORTHY22-Oct-07 1:49 
QuestionIntellisense not working Pin
cyber-drugs6-Sep-07 3:59
membercyber-drugs6-Sep-07 3:59 
GeneralEditor and underscore Pin
One_Turtle29-Aug-07 4:13
memberOne_Turtle29-Aug-07 4:13 
QuestionWon't connect? Pin
jholovacs24-Jul-07 3:35
memberjholovacs24-Jul-07 3:35 
GeneralSQL Intellisense Pin
Ravi Gyani27-Apr-07 11:57
memberRavi Gyani27-Apr-07 11:57 
I recently tried out KNOCKS SQL-Sense,

It is free and is good while using SQL Query Analyser.

Ravi Gyani

QuestionProblem with font Pin
oaxaca_salsa2-Apr-07 23:53
memberoaxaca_salsa2-Apr-07 23:53 
QuestionDoes it support Oracle10g? Pin
hermanho12-Mar-07 5:11
memberhermanho12-Mar-07 5:11 
VEMS10-Jan-07 10:49
memberVEMS10-Jan-07 10:49 
GeneralApplication Gives Error each time Pin
Manish Chowdhary6-Nov-06 18:28
memberManish Chowdhary6-Nov-06 18:28 
QuestionDoes anyone know of a visual SQL editor? Pin
Paul Touzel13-Jun-06 3:16
memberPaul Touzel13-Jun-06 3:16 
GeneralChanging default port Pin
e1e0n2-Mar-06 5:28
membere1e0n2-Mar-06 5:28 
GeneralRe: Changing default port Pin
e1e0n2-Mar-06 6:09
membere1e0n2-Mar-06 6:09 
Axiao790128-Feb-06 9:18
memberAxiao790128-Feb-06 9:18 
Diamond118-Jun-06 23:10
memberDiamond118-Jun-06 23:10 
Questionwhich tools you use to make your pictures like your post in this page? Pin
silas_yao22-Feb-06 18:23
membersilas_yao22-Feb-06 18:23 
AnswerRe: which tools you use to make your pictures like your post in this page? Pin
wmmihaa12-Aug-06 12:05
memberwmmihaa12-Aug-06 12:05 
GeneralSuggestion to add stored procedure generation Pin
Manish A Pansiniya2-Jan-06 20:57
memberManish A Pansiniya2-Jan-06 20:57 
GeneralRe: Suggestion to add stored procedure generation Pin
Manish Pansiniya13-Dec-06 6:29
memberManish Pansiniya13-Dec-06 6:29 
GeneralQueryCommander SQL Editor rocks Pin
cpsagman27-Nov-05 10:53
membercpsagman27-Nov-05 10:53 
GeneralGreat app Pin
kin3tik20-Nov-05 21:34
memberkin3tik20-Nov-05 21:34 
GeneralQC 4.0 is not working..:( Pin
Kelraad4-Oct-05 4:17
memberKelraad4-Oct-05 4:17 
GeneralRe: QC 4.0 is not working..:( Pin
wmmihaa12-Aug-06 12:10
memberwmmihaa12-Aug-06 12:10 
GeneralOracle Issue Pin
JC@Rio29-Sep-05 4:00
memberJC@Rio29-Sep-05 4:00 
GeneralRe: Oracle Issue Pin
Pavel Riedl4-Oct-05 1:45
sussPavel Riedl4-Oct-05 1:45 
GeneralRe: Oracle Issue Pin
shaul_ahuva19-Oct-05 7:03
membershaul_ahuva19-Oct-05 7:03 
GeneralRe: Oracle Issue Pin
Joshua_C#12-Feb-09 20:45
memberJoshua_C#12-Feb-09 20:45 
QuestionAnd Intellissense in other servers? Pin
silverius28-Sep-05 1:34
membersilverius28-Sep-05 1:34 
AnswerRe: And Intellissense in other servers? Pin
Mikael Håkansson28-Sep-05 4:57
memberMikael Håkansson28-Sep-05 4:57 
GeneralRe: And Intellissense in other servers? Pin
Bob Trudeau5-Oct-05 8:36
memberBob Trudeau5-Oct-05 8:36 
GeneralApplication crashes on replace Pin
Vertyg027-Sep-05 11:06
memberVertyg027-Sep-05 11:06 
GeneralRe: Application crashes on replace Pin
Mikael Håkansson27-Sep-05 20:32
memberMikael Håkansson27-Sep-05 20:32 
GeneralRe: Application crashes on replace Pin
Vertyg027-Sep-05 23:15
memberVertyg027-Sep-05 23:15 
GeneralRe: Application crashes on replace Pin
Mikael Håkansson27-Sep-05 23:17
memberMikael Håkansson27-Sep-05 23:17 
GeneralRe: Application crashes on replace Pin
Vertyg028-Sep-05 3:36
memberVertyg028-Sep-05 3:36 
GeneralScreen "real estate" and other suggestions Pin
Tony J. Vites9-Aug-05 4:13
sussTony J. Vites9-Aug-05 4:13 
GeneralRe: Screen "real estate" and other suggestions Pin
Mikael Håkansson9-Aug-05 6:38
memberMikael Håkansson9-Aug-05 6:38 
GeneralRe: Screen "real estate" and other suggestions Pin
Lindsey Lewis28-Sep-05 5:50
memberLindsey Lewis28-Sep-05 5:50 

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.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.151126.1 | Last Updated 27 Sep 2005
Article Copyright 2005 by Mikael Håkansson
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid