ExamGuru IT/.Net Guru : odbc database schema on microsoft.public.dotnet.framework.odbcnet

.NETGURU

odbc database schema

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.odbcnet.

Robin HOIZEY \(Hotmail\)

Hi everybody,

I'm trying to use an odbc connection to get the list of the available tabls
in my database. But I cant't find the right way to do this.

Can you help me ??

Reply to this message...

Paul Clement

On Thu, 10 Jun 2004 21:12:33 -1000, "Robin HOIZEY \(Hotmail\)" <Click here to reveal e-mail address> wrote:

¤ Hi everybody,
¤
¤ I'm trying to use an odbc connection to get the list of the available tabls
¤ in my database. But I cant't find the right way to do this.

You don't indicate what type of database you are working with but the ODBC Provider for .NET doesn't
support the retrieval of schema information. Use the OLEDB Provider for .NET instead.

Dim DatabaseConnection As New System.Data.OleDb.OleDbConnection
Dim SchemaTable As DataTable

DatabaseConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\db1.mdb"

DatabaseConnection.Open()

SchemaTable =
DatabaseConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, _
New Object() {Nothing, Nothing, Nothing, Nothing})

Dim RowCount As Int32
For RowCount = 0 To SchemaTable.Rows.Count - 1
Console.WriteLine(SchemaTable.Rows(RowCount)!TABLE_NAME.ToString)
Next RowCount

DataGrid1.DataSource = SchemaTable

DatabaseConnection.Close()

Paul ~~~ Click here to reveal e-mail address
Microsoft MVP (Visual Basic)

Reply to this message...

	System.Console
	System.Data.DataTable
	System.Data.OleDb.OleDbConnection
	System.Data.OleDb.OleDbSchemaGuid

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification