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

//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()

查询表及名称： SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (Left$([Name],4) "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name

select 表a.姓名,表a.是否,表1.邮编,表1.单位,表1.地址 from 表a,表1 where 表1.单位=表a.单位 and 表a.是否='y'

union

select 表b.姓名,表b.是否,表2.邮编,表2.单位,表2.地址 from 表b,表2 where 表2.单位=表b.单位 and 表b.是否='y'

union

......

---