获取所有表
string connnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Xtxx.db.dbwz;
OleDbConnection connection = new OleDbConnection(connnectionString);
connection.Open();
DataTable table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in table.Rows)
{
TreeNode treeNode = new TreeNode();
treeNode.Tag = "数据表";
treeNode.Text = row["TABLE_NAME"].ToString();
tvSjk.SelectedNode.Nodes.Add(treeNode);
}
connection.Close();
获取数据表详细信息
string connnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Xtxx.db.dbwz;
OleDbConnection connection = new OleDbConnection(connnectionString);
connection.Open();
DataTable table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, sjbmc, null });
int i =