#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# datatable中重复数据去重的内容,更多相关内容请关注php中文网(www.php.cn)!
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号