public List<string> GetTables()
{
List<string> Tables = new List<string>();
using (OleDbConnection Con = new OleDbConnection(StrCon))
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
DataTable schemaTable = Con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] { null, null, null, "TABLE" });
foreach (DataRow DR in schemaTable.Rows)
{
Tables.Add(DR["TABLE_NAME"].ToString());
}
}
return Tables;
}
Con连接对象 经测试 正确!