ADO.Net with OLE Db

[pvbangera]

hi,

i am using ole db to connect access database through ado.net.

after connection is made i want to populate all the tablenames in the database into my listbox on the form. and by default the 1st table should be opened and the data should get populated in the dbgrid.

pls guide, its urgent.

[nemaroller]

Google, always GOOGLE!

http://www.dotnetextreme.com/code/getdbschema.asp

[pvbangera]

Thanx for the link

I use the following code to list all the tables in an mdb file.

dbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName & ";Persist Security Info=False")
dbConnection.Open()
lstObjects.DataSource = dbTable

The code is working fine. But I dont want to list all the columns (like Table_Catalog, Table_Schema, etc). I just want only 4 cols (Name, Description, Date created and Date modified)

Also, after listing the tables, how to open a selected table from the list in DBGrid? I am finding ADO.Net very much confusing.

Please guide.

Regards