Click here to Skip to main content
Click here to Skip to main content

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

Comments and Discussions

Bugis dead? PinmemberMember 458010525-May-14 22:38 
Questionupdates Pinmemberkiquenet.com12-Jun-13 22:11 
GeneralMy vote of 5 PinmemberAbinash Bishoyi5-Mar-13 7:44 
GeneralMy vote of 5 PinmvpKanasz Robert25-Sep-12 23:52 
QuestionAdding stored procedures to Drag and Drop Pinmemberstain35653-Nov-11 3:50 
GeneralDocking panels - preventing dragging Pinmemberstain356517-Jun-11 1:39 
Questionany updates for sql server 2008 an oracle 10i ?? Pinmemberalhambra-eidos27-Dec-10 1:49 
GeneralA great application Pinmemberzhoufoxcn13-May-10 22:35 
GeneralMissing "normally expected" features PinmemberPandele Florin29-Sep-09 8:26 
QuestionSupport Oracle 10g ? Pinmemberalhambra-eidos22-May-09 0:14 
QuestionQueryCommander SQL Editor License Pinmemberirinabe20-Jan-09 1:27 
We have come across your code about "QueryCommander SQL Editor". We would like to use your editor and we are interested to know what is the type of license attached to it among all the licenses specified here?
AnswerRe: QueryCommander SQL Editor License Pinmemberjohn_17265-Mar-10 10:51 
GeneralI couldnt get it to work Pinmemberuofakron13-Nov-07 10:26 
GeneralSybase Support PinmemberC.DHAKCHINA MOORTHY22-Oct-07 1:49 
QuestionIntellisense not working Pinmembercyber-drugs6-Sep-07 3:59 
GeneralEditor and underscore PinmemberOne_Turtle29-Aug-07 4:13 
QuestionWon't connect? Pinmemberjholovacs24-Jul-07 3:35 
GeneralSQL Intellisense PinmemberRavi Gyani27-Apr-07 11:57 
QuestionProblem with font Pinmemberoaxaca_salsa2-Apr-07 23:53 
QuestionDoes it support Oracle10g? Pinmemberhermanho12-Mar-07 5:11 
GeneralSET QUOTED_IDENTIFIER PinmemberVEMS10-Jan-07 10:49 
GeneralApplication Gives Error each time PinmemberManish Chowdhary6-Nov-06 18:28 
QuestionDoes anyone know of a visual SQL editor? PinmemberPaul Touzel13-Jun-06 3:16 
GeneralChanging default port Pinmembere1e0n2-Mar-06 5:28 
GeneralRe: Changing default port Pinmembere1e0n2-Mar-06 6:09 
GeneralHELP ME!PLEASE PinmemberAxiao790128-Feb-06 9:18 
GeneralRe: HELP ME!PLEASE PinmemberDiamond118-Jun-06 23:10 
Questionwhich tools you use to make your pictures like your post in this page? Pinmembersilas_yao22-Feb-06 18:23 
AnswerRe: which tools you use to make your pictures like your post in this page? Pinmemberwmmihaa12-Aug-06 12:05 
GeneralSuggestion to add stored procedure generation PinmemberManish A Pansiniya2-Jan-06 20:57 
GeneralRe: Suggestion to add stored procedure generation PinmemberManish Pansiniya13-Dec-06 6:29 
GeneralQueryCommander SQL Editor rocks Pinmembercpsagman27-Nov-05 10:53 
GeneralGreat app Pinmemberkin3tik20-Nov-05 21:34 
GeneralQC 4.0 is not working..:( PinmemberKelraad4-Oct-05 4:17 
GeneralRe: QC 4.0 is not working..:( Pinmemberwmmihaa12-Aug-06 12:10 
GeneralOracle Issue PinmemberJC@Rio29-Sep-05 4:00 
GeneralRe: Oracle Issue PinsussPavel Riedl4-Oct-05 1:45 
GeneralRe: Oracle Issue Pinmembershaul_ahuva19-Oct-05 7:03 
GeneralRe: Oracle Issue PinmemberJoshua_C#12-Feb-09 20:45 
QuestionAnd Intellissense in other servers? Pinmembersilverius28-Sep-05 1:34 
AnswerRe: And Intellissense in other servers? PinmemberMikael Håkansson28-Sep-05 4:57 
GeneralRe: And Intellissense in other servers? PinmemberBob Trudeau5-Oct-05 8:36 
GeneralApplication crashes on replace PinmemberVertyg027-Sep-05 11:06 
GeneralRe: Application crashes on replace PinmemberMikael Håkansson27-Sep-05 20:32 
GeneralRe: Application crashes on replace PinmemberVertyg027-Sep-05 23:15 
GeneralRe: Application crashes on replace PinmemberMikael Håkansson27-Sep-05 23:17 
GeneralRe: Application crashes on replace PinmemberVertyg028-Sep-05 3:36 
GeneralScreen "real estate" and other suggestions PinsussTony J. Vites9-Aug-05 4:13 
GeneralRe: Screen "real estate" and other suggestions PinmemberMikael Håkansson9-Aug-05 6:38 
GeneralRe: Screen "real estate" and other suggestions PinmemberLindsey Lewis28-Sep-05 5:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.150326.1 | Last Updated 27 Sep 2005
Article Copyright 2005 by Mikael Håkansson
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid