datatable 去重

 

static void Main(string[] args)
{
DataTable dt = CreateTable();
dt.AsEnumerable().ToList().ForEach(
x =>
{
Console.WriteLine(x["name"].ToString() + " " + x["sex"].ToString());
});
Console.WriteLine();
var _comPresult = dt.AsEnumerable().Distinct(new DataTableRowCompare("name"));
DataTable _resultDt = _comPresult.CopyToDataTable();
_resultDt.AsEnumerable().ToList().ForEach(
x =>
{
Console.WriteLine(x["name"].ToString() + " " + x["sex"].ToString());
});

Console.WriteLine();
Console.ReadLine();
}
private static DataTable CreateTable()
{
DataTable dt = new DataTable();
dt.Columns.Add("name");
dt.Columns.Add("sex");
DataRow dr = dt.NewRow();
dr["name"] = "陈康";
dr["sex"] = "男";
DataRow dr1 = dt.NewRow();
dr1["name"] = "陈康";
dr1["sex"] = "女";
DataRow dr2 = dt.NewRow();
dr2["name"] = "赵敏";
dr2["sex"] = "男";
DataRow dr3 = dt.NewRow();
dr3["name"] = "赵敏";
dr3["sex"] = "女";
dt.Rows.Add(dr);
dt.Rows.Add(dr1);
dt.Rows.Add(dr2);
dt.Rows.Add(dr3);
return dt;
}

/// <summary>
/// 对datatable按字段去重
/// </summary>
public class DataTableRowCompare : IEqualityComparer<DataRow>
{
public string strCol { get; set; }
public DataTableRowCompare(string strColumn)
{
strCol = strColumn;
}
#region IEqualityComparer<DataRow> 成员

public bool Equals(DataRow x, DataRow y)
{
return (x.Field<string>(strCol) == y.Field<string>(strCol));
}

public int GetHashCode(DataRow obj)
{
return obj.ToString().GetHashCode();
}

#endregion
}