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'