Get all table names from Microsoft Access (MDB) database file
Filed in SQL on Mar.23, 2006
con.Open();
DataTable dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, “TABLE”});
for (int i=0;i< dt.Rows.Count;i++)
{
MessageBox.Show( dt.Rows[i]["TABLE_NAME"].ToString());
}
con.Close();
Related posts:
Leave a Reply
You must be logged in to post a comment.