获取所有表名
public List<string> GetTables()
{
OleDbConnection Conn = null; //需要自己构建,我这里为了方便就赋值了null
List<string> list = new List<string>();
try
{
if (Conn.State == ConnectionState.Closed)
Conn.Open();
DataTable dt = Conn.GetSchema("Tables");
foreach (DataRow row in dt.Rows)
{
list.Add(row[2].ToString());
}
}
catch (Exception e)
{
list = new List<string>();
}
return list;
}