Saturday, January 17, 2015

Delete Duplicate Rows from DataTable in C#

 You have a Data Table-dt
 To remove duplicate records from dt.

for (int i = 0; i < dt.Rows.Count-1; i++) 
{ 
  for (int j = i+1; j < dt.Rows.Count; j++) 
  { 
    if (dt.Rows[i].ItemArray.SequenceEqual(dt.Rows[j].ItemArray)) 
      dt.Rows[j].Delete(); 
  } 
} 
»Keep Sharing and Learning«

No comments:

Post a Comment