Click here to Skip to main content
13,506,729 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


49 bookmarked
Posted 9 Oct 2008

Simple Query Tool to Extract Data from Database

, 9 Oct 2008
Rate this:
Please Sign up or sign in to vote.
This is a simple user friendly query tool which helps end-users to extract data from the database. The UI looks similar to query windows in Team Foundation Server, this is a modest beginning which can be enhanced and used more effectively.


The are various ways to design a UI that helps users to extract specific information from the database. This tool whose UI design is similar to the queries windows in TFS helps users to extract specific data by helping the user to create or form a query.


This idea is similar to the query tools available in SQL server and TFS, but it is customized to the user's needs.

Using the Code

The Query tool hosts various controls in the grid, which get added on the fly while the user clicks through each of the cells, but still makes sure the user doesn't end up creating a garbled query.

Event based Asynchronous programming is done in case the query execution turnaround time is more, so for good user experience a progress bar is added to show the user that the query is been processed.

Interesting articles would be the following ones from MSDN:

  1. How to: Host Controls in Windows Forms DataGridView Cells

    This tools hosts Calender, ComboBox and Treeview controls in a ComboBox.



  2. How to: Wrap a Windows Forms Control with ToolStripControlHost

  3. Safe, Simple Multithreading in Windows Forms

    // Hosting the Controls in the Grid View
    public class CalendarColumn : DataGridViewColumn
    public class CalendarCell : DataGridViewTextBoxCell
    class CalendarEditingControl : DateTimePicker, IDataGridViewEditingControl
    // Asynchronous Programming to Update the UI
    class ShowProgressDelegate : MulticastDelegate {
      public void Invoke(int digits);
      public void BeginInvoke(string txtDisplay, AsyncCallback callback,
                              object asyncState);
      public void EndInvoke(IAsyncResult result);
    public class ToolStripControlHost : ToolStripItem 

Points of Interest

While developing the tool, it helped me in learning the various properties of control, hosting those controls in the grid view and do asynchronous programming.


  • 10th October, 2008: Initial release

This is just a fast track beginning, the future release would include all the fixes and an additional feature to group the clause.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Mohammad Hamed Akhter
Software Developer
India India
My Skills are C#.NET 2.0 and ASP.NET 2.0

You may also be interested in...


Comments and Discussions

GeneralThe project doesn't compile under VS2008 Pin
EAmez21-Mar-11 0:58
memberEAmez21-Mar-11 0:58 

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.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180417.1 | Last Updated 10 Oct 2008
Article Copyright 2008 by Mohammad Hamed Akhter
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid