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

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





/// <summary>

    /// 取所有表名

    /// </summary>

    /// <returns></returns>

    publicList<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 indt.Rows)

            {

                if(row[3].ToString() == "TABLE")

                    list.Add(row[2].ToString());

            }

            returnlist;

        }

        catch(Exception e)

        {throw e; }

        finally{ if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); }

    }

 

    /// <summary>

    /// 取指定表所有字段名称

    /// </summary>

    /// <returns></returns>

    publicList<string> GetTableFieldNameList(stringTableName)

    {

        List<string> list =new List<string>();

        OleDbConnection Conn =new OleDbConnection(ConnStr);

        try

        {

            if(Conn.State == ConnectionState.Closed)

                Conn.Open();

            using(OleDbCommand cmd = newOleDbCommand())

            {

                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));

                }

            }

            returnlist;

        }

        catch(Exception e)

        {throw e; }

        finally

        {

            if(Conn.State == ConnectionState.Open)

                Conn.Close();

            Conn.Dispose();

        }

    }