How to get duplicate rows?

@SHAISTA

You have to replace dt with your datatable Variable and assign the result to one more datatable variable**

(From p in dt.Select()
where( From q in dt.Select()
where string.Join(“,”,q.ItemArray).Equals(string.Join(“,”,p.ItemArray))
Select q).ToArray.Count>1
Select p).ToArray.CopyToDataTable

Regards
Mahesh

2 Likes