Found Duplicate record in excel sheet using c# .net

Question

I've a datatable that has been filled by excel sheet, it has lots of product id's and some other data. I want to check if there is any duplicate product id in my datatable and tell user that these prodcuts ids are duplicates or something like that.

Lmbda, Linq , Looping anything will do.

Thanks

Check out this SO question - LINQ to DataTable, finding duplicate rows — Tim
– Tim, Commented Jul 24, 2011 at 7:16

Community · Accepted Answer · 2017-05-23 11:47:51Z

3

Here's a slightly modified version of another answer C# Linq finding duplicate row:

var qry =  from p in Products
           group p by p.productID into grp
           where grp.Count() > 1
           select grp;

foreach (var product in qry)
{
    // Do something as needed/desired
}

Products is the DataTable, productID is the product ID; substitute appropriate names from your code as needed. I haven't tested this, but it should at least get you pointed in the right direction.

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Jul 24, 2011 at 7:28

Tim

28.6k8 gold badges65 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Found Duplicate record in excel sheet using c# .net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related