Question

怎样将DataTable中的重复数据筛选出来

Answer 1

var groupByResult = dataTable.Rows.Cast<DataRow>().GroupBy<DataRow, string>(dr => dr["name"].ToString()); foreach (var rows in groupByResult) { if (rows.Count() > 1) { //以name为筛选条件的数据存在多条 … } }