C# Help Home » Articles » C# Language » QueryBuilder in C#

QueryBuilder in C#

15. Apr, 2006 by admin 0 Comments

This application is that of a QueryBuilder in CSharp.This application is for Beta2 SDK version of DotNetFramework.I have used Oracle as the backend.For database connectivity and related operations, I have used System.Data.Odbc.dll file.For this application you'll have to download and install Oracle.NET from the Microsoft site. And yes you need the Microsoft.Net Framework installed on your machine(That goes without saying).The path of System.Data.Odbc.dll file may differ from the path of your application.If you wish you can copy the dll file in the folder in which you have your application.

How the application works:

The GUI is a Windows Form which has aMainmenu,Buttons,TextBox ,ListBox and Statusbar.You can get connected to the database by clicking on the Connect button.You have to provide DSN name,Username and Password to connect to thedatabase(assuming you are using Oracle as the database).You can select all the tables by clicking on the UserTables button.Onlyfive tables are displayed at a time and you can click the NextRowSetbutton to move to the next five tables and so on.There is an execute button to execute any query.If the query is forselecting records ,again only five records are displayed per page andyou can click the NextRowSet button to move to the next five recordsand so on.The disconnect button gets you disconnected from the database.Mainmenu consists of three Menuitems File,Edit and Status.You can usethe different File menu items to perform file related operations.EditMenuitems consist of cut,copy and paste options.Status menuitemcontrols the visibility of the statusbar.

There are two files queryanal.cs and connect.cs.

Compile the files by using the following command:
csc /r:System.Data.Odbc.dll queryanal.cs connect.cs

Download QueryBuilder.zip