65.9K
CodeProject is changing. Read more.
Home

List of Tables of Microsoft Access DataBase

starIconstarIconstarIconstarIconstarIcon

5.00/5 (2 votes)

Feb 17, 2011

CPOL
viewsIcon

19408

While dealing with databases, sometimes there is a need to get a list of tables in the application

If you are making an application where you need to deal with a database, the following piece of code can help you in getting a list of available tables in the database.
void table()
        {
            string path = @"D:\....... your database file path";
            listBox1.Items.Clear();
            textBox1.Text = "";
            mycon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Persist Security Info=True");
            mycon.Open();
            DataTable tables = mycon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            foreach (DataRow row in tables.Rows)
                listBox1.Items.Add(row[2]);
            mycon.Close();
            mycon.Dispose();
        }
Although there are many other methods, I have kept it simple for beginners. Welcome to suggestions.