#region 删除DataTable重复列,类似distinct /// /// 删除DataTable重复列,类似distinct /// /// DataTable /// 字段名 /// 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); } } } } indexList.Sort(); // 排序 for (int i = indexList.Count - 1; i >= 0; i--)// 根据待删除索引列表删除行 { int index = Convert.ToInt32(indexList[i]); dt.Rows.RemoveAt(index); } return dt; } /// /// 判断数组中是否存在 /// /// 数组 /// 索引 /// 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