Fields in a Access table

  • Thread starter Thread starter Who
  • Start date Start date
W

Who

What is the easiest way to get the names of the fields in an Access database
table using VB.net 2005 and ADO.net?

MBS
 
¤ What is the easiest way to get the names of the fields in an Access database
¤ table using VB.net 2005 and ADO.net?
¤

Below is an example of what Cor was referring to:

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

DatabaseConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Test Files\db1 XP.mdb"

DatabaseConnection.Open()

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

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

'Shows what column schema info is available
DataGrid1.DataSource = SchemaTable

DatabaseConnection.Close()


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top