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

最新推荐文章于 2024-09-18 15:52:40 发布

转载最新推荐文章于 2024-09-18 15:52:40 发布 · 1.7k 阅读

标签

#access #c# #exception #list #string

.NET备忘录专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一种使用OleDbConnection从指定数据库中获取所有表名及指定表的所有字段名称的方法。通过打开数据库连接并调用GetSchema方法来获取表信息，并通过执行SQL查询获取字段名称。

       
       /// <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();
           }
       }