Hi,
I am working on a program that I would like to use to connect to a database and view the table data from the front-end GUI.
I know how to use VB.NET to connect to the database, and I use the dataAdapter wizard to select what tables and columns I would like to view from within the application at design time. But how do you do this at runtime?
I can establish the connection at runtime but is there anyway to list the tables within any type of database? I need something like ORACLES, Select * from Tabs command that lists all the table names but is supported within VB.NET for virtually any database.
Am I approaching this wrong? Is there such a command? I saw one other similar inquiry in the forums that seemed to be what I was looking for but it seemed to be only for MSSQL databases. It was "select * from Employee.information_schema.tables" where Employee is the name of the database.
So, is there a way to list all the databases before a connection is established at runtime. Something like using the udl dialog?
Any help would be appreciated.
Thanks,
mivey4
I am working on a program that I would like to use to connect to a database and view the table data from the front-end GUI.
I know how to use VB.NET to connect to the database, and I use the dataAdapter wizard to select what tables and columns I would like to view from within the application at design time. But how do you do this at runtime?
I can establish the connection at runtime but is there anyway to list the tables within any type of database? I need something like ORACLES, Select * from Tabs command that lists all the table names but is supported within VB.NET for virtually any database.
Am I approaching this wrong? Is there such a command? I saw one other similar inquiry in the forums that seemed to be what I was looking for but it seemed to be only for MSSQL databases. It was "select * from Employee.information_schema.tables" where Employee is the name of the database.
So, is there a way to list all the databases before a connection is established at runtime. Something like using the udl dialog?
Any help would be appreciated.
Thanks,
mivey4
