Access 获取数据库表名和字段名

//获取Access数据库表的字段名
        public List<string> GetTableFieldNameList(string TableName)
        {
            string conStr = "provider=microsoft.jet.oledb.4.0;";
            conStr += @"data source=" + 数据库的路径（例如："D:\\data\\test.mdb"）
            List<string> list = new List<string>();
            OleDbConnection con = new OleDbConnection(conStr);
            try
            {
                con.Open();
                using (OleDbCommand cmd = new OleDbCommand())
                {
                    cmd.CommandText = "SELECT TOP 1 * FROM [" + TableName + "]";
                    cmd.Connection = con;
                    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 (con.State == ConnectionState.Open)
                    con.Close();
                con.Dispose();
            }
        }

//获取Access数据库表名集合
        public ArrayList GetTableNameList(string filePath)
        {
            string conStr = "provider=microsoft.jet.oledb.4.0;";
            conStr += @"data source=" + filePath;
            ArrayList tableList = new ArrayList();
            OleDbConnection con = new OleDbConnection(conStr);
            try
            {
                con.Open();
                //第一种方法
                /*DataRow [] rows = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Select();
                for (int i = 0; i < rows.Length; i++)
                {
                    if (!rows[i]["TABLE_NAME"].ToString().Contains("MSys"))
                    {
                        tableList.Add(rows[i]["TABLE_NAME"].ToString());
                    }
                }
                return tableList;*/
                //第二种方法
                DataTable dt = con.GetSchema("Tables");
                foreach (DataRow row in dt.Rows)
                {
                    if (row[3].ToString() == "TABLE")
                        tableList.Add(row[2].ToString());
                }
                return tableList;
            }
            catch (Exception e)
            { 
                throw e; 
            }
            finally 
            { 
                if (con.State == ConnectionState.Open)
                    con.Close();
                con.Dispose(); 
            }
        }

添加Access数据库的的字段名

alter table tableName add column 字段名 int