MSDOTnet.org Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

retrieving list of tables

 
Post new topic   Reply to topic    MSDOTnet.org Forum Index -> ODBC Dotnet
Author Message
gyoder



Joined: 08 Aug 2007
Posts: 2
PostPosted: Mon May 29, 2006 1:25 am    Post subject: retrieving list of tables Reply with quote
how do i get a list of tables after issuing odbcconnection.open? i'm able to
open the connection and use odbcconnection.getschema but is there a generic
method that returns table list?

thanks

Archived from group: microsoft>public>dotnet>framework>odbcnet
Back to top
View user's profile Send private message
Paul Clement



Joined: 08 Aug 2007
Posts: 154
PostPosted: Tue May 30, 2006 2:09 pm    Post subject: Re: retrieving list of tables Reply with quote
On Sun, 28 May 2006 21:25:45 -0400, "gyoder" wrote:

¤ how do i get a list of tables after issuing odbcconnection.open? i'm able to
¤ open the connection and use odbcconnection.getschema but is there a generic
¤ method that returns table list?
¤

Dim ODBCDatabaseConnection As New Odbc.OdbcConnection

ODBCDatabaseConnection.ConnectionString = "DSN=AccessDB"
ODBCDatabaseConnection.Open()

Dim TableSchema As DataTable

TableSchema = ODBCDatabaseConnection.GetSchema("tables")

DataGridView1.DataSource = TableSchema

ODBCDatabaseConnection.Close()


Paul
~~~~
Microsoft MVP (Visual Basic)
Back to top
View user's profile Send private message
J T



Joined: 16 Aug 2007
Posts: 1
PostPosted: Wed Aug 08, 2007 6:27 pm    Post subject: Re:retrieving list of tables Reply with quote
I needed the same thing, and this post helped me.

thanks
Jd
Back to top
View user's profile Send private message
connection



Joined: 28 Sep 2007
Posts: 1
PostPosted: Mon Sep 17, 2007 1:58 am    Post subject: Re:retrieving list of tables Reply with quote
"J T" wrote:

> I needed the same thing, and this post helped me.
>
> thanks
> Jd
>
Back to top
View user's profile Send private message
Display posts from previous:   
Related Topics:
How do I get a list of tables associated with my DSN? I'm writing a Visual Basic .NET application and am using the class. With that can I get a list of tables associated with a DSN? Thanks in Advance, Eddie

List of Tables in Database? Is there any way to access the list of tables that are available via a particular ODBC connection? --Bruce

Retriving DSN list and their associated databases and tables Hello I need help for the following: 1)Retrieve DSN list in Combo Box 2)After Selecting the DSN,select the Database 3)After Selection of Database,it list down all tables and their associated fields -Is it guide me Thanks -adnan -----------

Getting a list of Tables in MS access database I have a need to list all the tables in a MS access database using ODBC. How can this be acheieved ?

Retriving DSN list and their associated databases and tables Hello I need help for the following: 1)Retrieve DSN list in Combo Box 2)After Selecting the DSN,select the Database 3)After Selection of Database,it list down all tables and their associated fields -Is it guide me Thanks -adnan -----------
Post new topic   Reply to topic    MSDOTnet.org Forum Index -> ODBC Dotnet All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group