Access table in DBGrid [Please resolve]

[pvbangera]

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

[pvbangera]

Pllllllleeeeeeeeaaaaaaaasssssssseeeeee... ITS URGENT

[Pirate]

This segment doesn't make sense , can you show more code this will help the guys here to offer better help !

[pvbangera]

OK!

I have imported System.Data.OleDb in my form.

Friend DBName As String
Friend dbTable As OleDbDataTable
Friend dbConnection As OleDbConnection
DBName = "c:\database\db1.mdb"
dbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName & ";Persist Security Info=False")
dbConnection.Open()
dbTable = dbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables_Info, New Object() {Nothing, Nothing, Nothing, "TABLE"})
lstTables.DataSource = dbTable

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

Now, further, I want to open a table in DBGrid when the user double clicks any item from the list box containing list of tables; so that the user can make necessary changes to the table.

Please guide how to proceed?

[Pirate]

Add the bolded line to your code and you get only table names .

Friend DBName As String
Friend dbTable As OleDbDataTable
Friend dbConnection As OleDbConnection
DBName = "c:\database\db1.mdb"
dbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName & ";Persist Security Info=False")
dbConnection.Open()
dbTable = dbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables_Info, New Object() {Nothing, Nothing, Nothing, "TABLE"})
lstTables.DataSource = dbTable
[B]lstTables.DisplayMember = "TABLE_NAME"[/B]