//读取标准列表
private void setModelList()
{
OleDbConnection Connection = null;
string tableName = "";
try
{
string strMdb = this.textBox5.Text;//mdb路径
Connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMdb + "");
Connection.Open();
DataTable schemaTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow dr in schemaTable.Rows)
{
//表名
tableName = dr["TABLE_NAME"].ToString();
//字段名
//DataTable columnTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, dr["TABLE_NAME"].ToString(), null });
//foreach (DataRow dr2 in columnTable.Rows)
//{
// Console.WriteLine("{0}", dr2["COLUMN_NAME"]);
//}
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
DataTable dt = new DataTable();
string sSql = "select * from " + tableName + "";
OleDbDataAdapter da = new OleDbDataAdapter(sSql, Connection);
da.Fill(dt);
this.gridControl1.DataSource = dt;
}
