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

最新推荐文章于 2022-05-18 17:44:27 发布

转载最新推荐文章于 2022-05-18 17:44:27 发布 · 1.7k 阅读

文章标签：

#access #c# #exception #list #table #cmd

C# 学习笔记专栏收录该内容

15 篇文章

订阅专栏

本文介绍了一种使用OleDbConnection连接数据库的方法，通过该方法可以获取数据库中所有的表名及指定表的所有字段名称。

http://www.cnblogs.com/swtseaman/archive/2011/08/20/2147150.html



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