By Jayant D. Kulkarni
This is a program to access a database using treeview control. It contains the parent database at the root and tables in that database that are the children of the root but siblings of each other. The Show button click causes the display of all tables in the database to appear and double clicking of each table causes to show column names in the table.
When you select a column you will see the data from the particular column. You can name the server and database name through the user input group box. The program is very simple and does not need much explanation. I have used string functions, database adapter as well as dataset ( for data tables ). You have to specify user name and password for connecting to a database if it is a remote database.
The program currently connects to SQL server and can be modified easily to connect to Oracle. Blue and Brown colors are used for diplaying tablenames and column names.
Download Source
Any suggestions, bugs, queries are always welcome.
I've been working with C# for 20 days ... still trying to get a grip
Jayant D. Kulkarni
Software Engineer
Savitr Software Srvices
Hyderabad
