Loading

Showing all data in access database file to datagridview

Umar Farooq

Actually I'm trying to connect my winform data mining application to access database files through open dialogue box . As I'm trying to connect to any unknown database file so, I've no knowledge about its table names.but for connecting database to datagridview you have to provide sql query as command. My question is that , is there any way through which i can load all data(records) in any connected access database file without specifying/knowing tables names of a access db file.

thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Umar Farooq10y ago
Actually , connecting procedure through OLE db requires atleast one query like SELECT * FROM tablename to load data to datagridview. but what if we are connecting access db file randomly through open dialogue and we are not aware of table name in the access database than how to mention table name in query.
Amit Kumar Singh10y ago
Through Store Procedure.....We can combine table to dataset.