Visual Studio .NET 2003Visual Studio 2008Visual Studio 2005Visual Studio 2010Database DevelopmentVisual Studio.NETC#
List of Tables of Microsoft Access DataBase





5.00/5 (2 votes)
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.