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();
}
浙公网安备 33010602011771号