By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,550 Members | 2,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,550 IT Pros & Developers. It's quick & easy.

GetOleDbSchemaTable

P: 1
GetOleDbSchemaTable
________________________________________
With the code down here, I can find all the Table Names of a database in Access, but ........ I like to know also the query-names of that database.

Can anybody tell me how to do this ? ?
I can't find it.


Greetings Bas.


Try
objConnection.Open()
dbTableNames = objConnection.GetOleDbSchemaTable(System.Data.OleD b.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

objConnection.Close()
Dim TabelNaam As String
Dim nr As Int16 = 0

For Each drTabelNamen In dbTableNames.Rows
TabelNaam = drTabelNamen.Item(2).ToString
MakeTableButtons(TabelNaam, nr)
nr = nr + 1
Next

.........
.........
May 2 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.