读书人

剔除DataTable重复列类似distinct

发布时间: 2012-09-09 09:27:54 作者: rapoo

删除DataTable重复列,类似distinct

        #region 删除DataTable重复列,类似distinct        /// <summary>        /// 删除DataTable重复列,类似distinct        /// </summary>        /// <param name="dt">DataTable</param>        /// <param name="Field">字段名</param>        /// <returns></returns>        public static DataTable DeleteSameRow(DataTable dt, string Field)        {            ArrayList indexList = new ArrayList();            // 找出待删除的行索引            for (int i = 0; i < dt.Rows.Count - 1; i++)            {                if (!IsContain(indexList, i))                {                    for (int j = i + 1; j < dt.Rows.Count; j++)                    {                        if (dt.Rows[i][Field].ToString() == dt.Rows[j][Field].ToString())                        {                            indexList.Add(j);                        }                    }                }            }            // 根据待删除索引列表删除行            for (int i = indexList.Count - 1; i >= 0; i--)            {                int index = Convert.ToInt32(indexList[i]);                dt.Rows.RemoveAt(index);            }            return dt;        }        /// <summary>        /// 判断数组中是否存在        /// </summary>        /// <param name="indexList">数组</param>        /// <param name="index">索引</param>        /// <returns></returns>        public static bool IsContain(ArrayList indexList, int index)        {            for (int i = 0; i < indexList.Count; i++)            {                int tempIndex = Convert.ToInt32(indexList[i]);                if (tempIndex == index)                {                    return true;                }            }            return false;        }        #endregion 

读书人网 >编程

热点推荐