Data Extraction till end page

Dear Forum Members,

I have a data table, and i want to remove duplicate rows based on three column.

If that three column contains exact same value, then duplicate row must be delete.

Please Suggest linq query.

thanks in advance.

Hi,

Hope this may help you. This is a linq query keeps one of the row from the duplicates values available in three columns

( From d in InputDT.AsEnumerable
Group d by k1=d(“ColumnName1”).toString.Trim, k2=d(“ColumnName1”).toString.Trim,k3=d(“ColumnName3”).toString.Trim, into grp= Group
let mbr = grp.First()
Select r=mbr).CopyToDataTable