Question reading field names from table

[sai87]

hi all,
i am new to vb.net, Is it possible to determine the column names in MS Access in a particular database using vb?

Can any one guide me in this issue?

 

[jmcilhinney]

You are presumably using an OleDbConnection. It has a GetSchema method. You can call that with no arguments and it will return a DataTable containing information about each collection you can query. Those collections will likely be things like TABLES and COLUMNS. You can then call GetSchema again and pass a collection name as an argument to get information about that collection.