#region datatable去重 /// <summary> /// datatable去重 /// </summary> /// <param name="dtSource">需要去重的datatable</param> /// <param name="columnNames">依据哪些列去重</param> /// <returns></returns> public static DataTable GetDistinctTable(DataTable dtSource, params string[] columnNames) { DataTable distinctTable = dtSource.Clone(); try { if (dtSource != null && dtSource.Rows.Count > 0) { DataView dv = new DataView(dtSource); distinctTable = dv.ToTable(true, columnNames); } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } return distinctTable; } /// <summary> /// datatable去重 /// </summary> /// <param name="dtSource">需要去重的datatable</param> /// <returns></returns> public static DataTable GetDistinctTable(DataTable dtSource) { DataTable distinctTable = null; try { if (dtSource != null && dtSource.Rows.Count > 0) { string[] columnNames = GetTableColumnName(dtSource); DataView dv = new DataView(dtSource); distinctTable = dv.ToTable(true, columnNames); } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } return distinctTable; } #endregion #region 获取表中所有列名 public static string[] GetTableColumnName(DataTable dt) { string cols = string.Empty; for (int i = 0; i < dt.Columns.Count; i++) { cols += (dt.Columns[i].ColumnName + ","); } cols = cols.TrimEnd(','); return cols.Split(','); } #endregion
위 내용은 C# 데이터 테이블의 중복 데이터 중복 제거 내용입니다. 더 많은 관련 내용은 PHP 중국어 홈페이지(www.php.cn)를 참고해주세요!