dataset 判断整列是否有重复,找出重复数据

DataTable dt = ds.Tables[0];
DataView dv = new DataView(dt);

if (dv.Count != dv.ToTable(true, jsonColumnNameNo).Rows.Count)
{


//有重复 取出重复数据
var repeatData = (from a in dt.AsEnumerable()
group a by a.Field<string>(jsonColumnNameNo)
into g
where g.Count() > 1
select new
{
value = g.Key
}).ToList();

}

posted @ 2024-03-09 15:46  過朢  阅读(91)  评论(0)    收藏  举报