c# 获取access所有表名 获取指定表所有字段名

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

/// <summary>     /// 取所有表名     /// </summary>     /// <returns></returns>     public List<string> GetTableNameList()     {         List<string> list = new List<string>();         OleDbConnection Conn = new OleDbConnection(ConnStr);         try         {             if (Conn.State == ConnectionState.Closed)                 Conn.Open();             DataTable dt = Conn.GetSchema("Tables");             foreach (DataRow row in dt.Rows)             {                 if (row[3].ToString() == "TABLE")                     list.Add(row[2].ToString());             }             return list;         }         catch (Exception e)         { throw e; }         finally { if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); }     }       /// <summary>     /// 取指定表所有字段名称     /// </summary>     /// <returns></returns>     public List<string> GetTableFieldNameList(string TableName)     {         List<string> list = new List<string>();         OleDbConnection Conn = new OleDbConnection(ConnStr);         try         {             if (Conn.State == ConnectionState.Closed)                 Conn.Open();             using (OleDbCommand cmd = new OleDbCommand())             {                 cmd.CommandText = "SELECT TOP 1 * FROM [" + TableName + "]";                 cmd.Connection = Conn;                 OleDbDataReader dr = cmd.ExecuteReader();                 for (int i = 0; i < dr.FieldCount; i++)                 {                     list.Add(dr.GetName(i));                 }             }             return list;         }         catch (Exception e)         { throw e; }         finally         {             if (Conn.State == ConnectionState.Open)                 Conn.Close();             Conn.Dispose();         }     }