Retrieving database schema

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,
--
Mark

Cor
Mon Aug 21 11:44:04 CDT 2006

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




"Mark" <Mark@discussions.microsoft.com> schreef in bericht
news:56B4D513-4F7E-45E0-932E-ABB452CDA39B@microsoft.com...
> 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,
> --
> Mark

Mark
Mon Aug 21 13:05:02 CDT 2006

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.
--
Mark


"Cor Ligthert [MVP]" wrote:

> 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
>
>
>
>
> "Mark" <Mark@discussions.microsoft.com> schreef in bericht
> news:56B4D513-4F7E-45E0-932E-ABB452CDA39B@microsoft.com...
> > 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,
> > --
> > Mark
>
>
>