C# mysql 获取所有表名

   public static List<string> GetAllTableName()
        {
            List<string> retNameList = new List<string>();
            DataTable tbName = m_Connectioin.GetSchema("Tables");// 这句是关键  Connectioin为连接 使用的是Mysql.Data.dll
            if (tbName.Columns.Contains("TABLE_NAME"))
            {
                foreach (DataRow dr in tbName.Rows)
                {
                    retNameList.Add((string)dr["TABLE_NAME"]);
                }
            }
          
            return retNameList;
        }

posted @ 2016-07-26 15:57  胖胖仔  阅读(1980)  评论(0编辑  收藏  举报