access读取mysql表_获取Access数据里所有表的名称和表的字段

//获取Access数据库表名

public void GetTableName()

{

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @"C:\信息技术考试成绩.mdb";

OleDbConnection conn = new OleDbConnection(connString);

conn.Open();

DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

conn.Close();

int n = dt.Rows.Count;

string[] tableName = new string[n];

int m = dt.Columns.IndexOf("TABLE_NAME");

for (int i = 0; i < n; i++)

{

DataRow dr = dt.Rows[i];

tableName[i] = dr.ItemArray.GetValue(m).ToString();

this.cbxtable.Items.Add(tableName[i].ToString());

}

this.cbxtable.SelectedIndex = 0;

}

///

/// 返回某一表的所有字段名

///

publ