Question

c# 获取access数据库所有的表名

我想要获取access数据库所有的表名，最好用sql语句，该怎么写代码？

Answer 1

//C#获取Access数据库中的所有表名和列名

string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=E:\report20100819\report20100819.mdb"; OleDbConnection Conn = new OleDbConnection(ConnectionString); Conn.Open();DataTable shemaTable = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); foreach (DataRow dr in shemaTable.Rows) { Console.WriteLine(dr["TABLE_NAME"]); DataTable columnTable = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, dr["TABLE_NAME"].ToString(), null }); foreach (DataRow dr2 in columnTable.Rows) { Console.WriteLine(dr2["COLUMN_NAME"]); } } Conn.Close();