Accessing a DB Using Tree View Control
This is a program to access a database usingtreeview control. It contains the parent database at the root andtables in that database that are the children of the root but siblingsof each other. The Show button click causes the display of all tablesin the database to appear and double clicking of each table causes toshow column names in the table.
When you select a column you will see the datafrom the particular column. You can name the server and database namethrough the user input group box. The program is very simple and doesnot need much explanation. I have used string functions, databaseadapter as well as dataset ( for data tables ). You have to specifyuser name and password for connecting to a database if it is a remotedatabase.
The program currently connects to SQL serverand can be modified easily to connect to Oracle. Blue and Brown colorsare used for diplaying tablenames and column names.




11. Jan, 2007 by 







No comments yet... Be the first to leave a reply!