How to remove the duplicate rows in a dataset

__________________
Shaalini.S
Be the Best of Whatever you are...

This method will remove the duplicate rows from a datatable, based on a column. Pass to the method the datatable and the column to be checked for duplicate values.


Call the method like this :



RemoveDuplicateRows(dT,"ID");



This is the implementation.



public void RemoveDuplicateRows(DataTable dTable,string colName)
{
Hashtable hTable = new Hashtable();
ArrayList duplicateList = new ArrayList();

foreach(DataRow drow in dTable.Rows)
{
try
{
hTable.Add(drow[colName],string.Empty);
}
catch
{
duplicateList.Add(drow);
}
}

foreach(DataRow dRow in duplicateList)
dTable.Rows.Remove(dRow);
}

I m getting the situation to pass multiple columns

__________________
Shaalini.S
Be the Best of Whatever you are...