示例C#中dataset删除重复数据的方法

/// <summary> 
        /// 获取对固定列不重复的新DataTable 
        /// </summary> 
        /// <param name="dt">含有重复数据的DataTable</param> 
        /// <param name="colName">需要验证重复的列名</param> 
        /// <returns>新的DataTable，colName列不重复，表格式保持不变</returns> 
        private DataTable GetDistinctTable(DataTable dt,string colName) 
        { 
            DataView dv = dt.DefaultView; 
            DataTable dtCardNo = dv.ToTable(true, colName); 
            DataTable Pointdt = new DataTable(); 
            Pointdt = dv.ToTable(); 
            Pointdt.Clear(); 
            for (int i = 0; i < dtCardNo.Rows.Count; i  ) 
            { 
                DataRow dr = dt.Select(colName   "='"   dtCardNo.Rows[i][0].ToString()   "'")[0]; 
                Pointdt.Rows.Add(dr.ItemArray); 
            } 
            return Pointdt; 
        }

本篇文章来源于 dotnet开源社区  原文链接：http://www.openaspx.com/article/201106/17/20110617124109.htm