Get table name from MS Access

Asked Dec 01 '19 at 18:32

Active Dec 01 '19 at 19:22

Viewed 61 times

I Want to get names of table from Ms Access into List. And I use

DataTable dt = con.GetSchema("TABLES");

foreach(DataRow dr in dt.Rows)
{
   SelectTable.Add(dr[2].ToString());
}

But there are many tables my List. How to get only my Table name?

edited Dec 01 '19 at 19:22

ASh

asked Dec 01 '19 at 18:32

Have a look at [this link](https://stackoverflow.com/a/15900849/3908810) to View Data from MS Access in Data Grid View – Saghachi Dec 01 '19 at 19:09
Review https://stackoverflow.com/questions/1699897/retrieve-list-of-tables-in-ms-access-file – June7 Dec 01 '19 at 19:47
@StudioX That may or may not be a good idea, because it's not just getting the table names, it's also retrieving all the data. – Zev Spitz Dec 01 '19 at 20:29
I SOLVED this problem Thanks – Shamyrat Nurgeldiyev Dec 02 '19 at 04:57

0 Answers0