//获取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;

}

///

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

///

public List GetTableColumn(string tableName)

{

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

OleDbConnection conn = new OleDbConnection(connString);

List list = new List();

DataTable dt = new DataTable();

try

{

conn.Open();

dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, tableName, null });

int n = dt.Rows.Count;

string[] strTable = new string[n];

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

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

{

DataRow dr = dt.Rows[i];

list.Add(dr.ItemArray.GetValue(m).ToString());

}

return list;

}

catch (Exception ex)

{

throw ex;

}

finally

{

conn.Close();

}

}

private void button3_Click(object sender, EventArgs e)

{

string str = this.cbxtable.SelectedItem.ToString();

{

List lst = GetTableColumn(str);

listBox1.DataSource = lst;

}

}