Tuesday, January 10, 2012

C# and MS SQL Database Connection Software

Using the software I have developed, it is easy to handle all the SQL server database information. When you run the software, it shows all the databases in the server. You can click on the particular database you want to manage.


 Then it shows the tables inside that database. You can click on the table name that you want to manage.



Then it shows all the data in that table. You can insert, update and delete records of that table. Once the modification is complete, press the appropriate button in the left side panel.

It is also possible to write your own SQL statements. It comes with a syntax highlighter. Currently the syntax is limited but you can add the commands in the project source code as you wish.


Click Here to download the Visual Studio 2008 project source code. (63.32 KB)

P.S - If the database connection fails, you will have to modify the App.config file in the project giving the correct server name, user name and password. Then rebuild the project.

-Tharindu Edirisinghe
-SLIIT 10'

3 comments:

Michaelmoody84 said...

Very simple and nice to use. Does this software available for free?

Tharindu Edirisinghe said...

Of course it is free. The source code can be downloaded from the link at the bottom of the post.

Inside the project folder, go to bin->debug. Then you can find the exe file of the software. Run it and see. If it doesn't work, you'll have to build the project using visual studio.
If you find any problem, just put a comment here. I'll help.

Hishan de Silva said...

එල...

Post a Comment