Friday, September 17, 2010

Remove Duplicate Records From a DataTable.

public DataTable DistinctRecordsFromDataTable(DataTable originalDT)
{
DataTable distinctDT = new DataTable();
DataView dv = originalDT.DefaultView;
System.Collections.Generic.List columns = new List();
//Add all the required columns which you want to get distinct to
//string list as follows
columns.Add("Column1");
columns.Add("Column2");
columns.Add("Column3");
columns.Add("Column4");
columns.Add("Column5");
distinctDT = dv.ToTable(true, columns.ToArray());
return distinctDT;
}

No comments:

Post a Comment