C # uses LINQ to implement a DataTable for Data de-duplication filtering

before filtering:

After filtering (only the exact same data is filtered out):

The code is as follows:

DataTable dt = this. Jsontodatatable ("[{\" code\ ": \" sortid\ ", \" name\ ": \" sortid\ "},{\" code\ ": \" sortcode\ ", \" name\ ": \" number \ "},{\" Code\ " : \ "solutionname\", \ "name\": \ "name \"},{\ "code\": \ "sortid\", \ "name\": \ "sortid\"},{\ "code\": \ "sortid\", \ "name\": \ "            Sortid\ "},{\" code\ ": \" sortid001\ ", \" name\ ": \" sortid\ "}]"); DataTable dtsort = dt.            Clone (); var query = from T in dt. AsEnumerable () group T by new {T1 = t.field<string> ("Code"), t2 = t.field<string> ("Name                            ")} into m select new {code = M.KEY.T1,            NAME=M.KEY.T2, rowcount = M.count ()}; if (query. ToList (). Count > 0) {query. ToList ().                    ForEach (q = {DataRow Dr = Dtsort.newrow ();                    dr["Code" = Q.code;                    dr["Name"] = Q.name; DtsoRt.                  Rows.Add (DR);            }); }

The above is C # using LINQ to implement the Data de-duplication filter content, more relevant content please pay attention to topic.alibabacloud.com (www.php.cn)!

