Retrieving database schema

[Guest]

Hi Everyone:
I’m new to the VB.NET development platform, and I’m trying to understand how
to retrieve database schema information from either of these databases:
Microsoft Access, Microsoft SQL Server 2000, or Oracle.

I recently bought a reference book titled “Beginning VB.NET Databases†by
Thearon Willis from WROX press. From this book I have found a way to
dynamically connect to any database and check to see if the connection was
successful.

What I would like to do is once the connection to the database is
established, show a list of the tables contained in the selected database. If
the user needs to add data to a specific table he would select the table he
needs to add the data too and the application would create a datasheet with
the columns (Fields) of the database shown in the order they where created in
the table. I would also like to label the primary key of the table and any
foreign keys that table references.

I’m having difficulty in finding examples of these types of operations. Can
anyone show me where to go to find this information.

Thank you,

 

[Cor Ligthert [MVP]]

Mark,

It are a lot of question, however there are probably more standard solutions
that fits on your problem.

Have a look at this.
http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252

Mostly it is better to start at the begin.

I hope this helps,

Cor

 

[Guest]

Cor,
That it are. I'll look at the recommended link and see what I can see. The
structure of VB.NET is so different from VB 6.0 that there is no common point
of referance.