C#中怎么才能读取Access数据库中的所有表?(高手请进->>>)

[pt870219]

C#中怎么才能读取Access数据库中的所有表?(高手请进->>>)

[sskset]

http://access911.net/fixhtm/71FAB71E12DC.htm

[sskset]

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;

[泡沫游走]

//添加System.Data.OleDb引用
private void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection Mycnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source= f:\\StudentDB.mdb");
DataTable schemaTable;
schemaTable = GetTables(Mycnn);
int i;
for (int i = 0; i <= schemaTable.Rows.Count - 1; i++) {
ListBox1.Items.Add(schemaTable.Rows(i).Item(2).ToString());
}
}

public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[]{null, null, null, "TABLE"});
conn.Close();
return schemaTable;
}

[ReViSion]

这样也行呀

[pt870219]

很好

[screwdriver112]

三楼的代码有错的。。。。

 string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbDir + ";Jet OLEDB:Database Password=cisdi;";//连接字符串
                    OleDbConnection Myconn = new OleDbConnection(connstr);
                    DataTable SchemaTalbe;
                    Myconn.Open();
                    SchemaTalbe = Myconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null,null,null,"TABLE"});
                    Myconn.Close();
                    for (int p = 0; p < SchemaTalbe.Rows.Count; p++)
                    {
//注意这句不是3楼写的那样，3楼对schematable的用法不了解。建议补下datatable。                        
MessageBox.Show(SchemaTalbe.Rows[p]["Table_Name"].ToString());
                    }

[screwdriver112]

 string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbDir + ";Jet OLEDB:Database Password=cisdi;";
                    OleDbConnection Myconn = new OleDbConnection(connstr);
                    DataTable SchemaTalbe;
                    Myconn.Open();
                    SchemaTalbe = Myconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null,null,null,"TABLE"});
                    Myconn.Close();
                    for (int p = 0; p < SchemaTalbe.Rows.Count; p++)
                    {
                        MessageBox.Show(SchemaTalbe.Rows[p]["Table_Name"].ToString());
                    }