C# datatable中重複資料去重

        #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中重複資料去重的內容，更多相關內容請關注topic.alibabacloud.com（www.php.cn）！

