C#读取access表，并把数据显示在gridcontrol中

//读取标准列表

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;

}