Question

用C#连接ACCESS数据库后，怎样能查到数据库有几个表，并将所有表名显示在listbox里，急求回复！！！

Answer 1

//using System.Data;
//using System.Data.OleDb;

this.listbox.Items.Clear();
try {
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID=admin;Data Source=your.mdb");
conn.Open();

DataTable table = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
foreach(DataRow drow in table.Rows) {
this.listbox.Items.Add(drow[2].ToString(), true);
}
conn.Close();
} catch {}

Answer 2

select Name from MSysObjects where [type]=1 and Name not like 'MSys%'"

MSysObjects 表 属性先改为可读可写 ,他是隐藏的

Answer 3

你使用SELECT * from MSysObjects;但需要过滤系统表和查询。

Answer 4

给你视频教材看
http://tech.163.com/06/0922/17/2RL25QKN0009215D.html