Try with this expression
(From p in DT.Select() where( From q in DT.Select() where q("MRN").Equals(p("MRN")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()
Check out the XAML file
RemoveDuplicateRows.xaml (9.4 KB)
Regards
Gokult
Try with this expression
(From p in DT.Select() where( From q in DT.Select() where q("MRN").Equals(p("MRN")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()
Check out the XAML file
RemoveDuplicateRows.xaml (9.4 KB)
Regards
Gokult