Hi,

I am having a datatable that consists of many records and name is duplicated many times in this table. I want to get the distinct records using name column.
Can anyone give me an idea to do this?

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

Hi,

This is the simple way to do this.

consider, sourceDataTable consists of duplicate records.

DataSet ds = new DataSet();
ds.Tables.Add(sourceDataTable);
DataTable distinctDataTable = SelectDistinct("DistinctTable", sourceDataTable, "name");



public DataTable SelectDistinct(string TableName, DataTable SourceTable, string FieldName)
{
DataTable dt = new DataTable(TableName);
dt.Columns.Add(FieldName, SourceTable.Columns[FieldName].DataType);

object LastValue = null;
foreach (DataRow dr in SourceTable.Select("", FieldName))
{
if (LastValue == null || !(ColumnEqual(LastValue, dr[FieldName])))
{
LastValue = dr[FieldName];
dt.Rows.Add(new object[] { LastValue });
}
}

return dt;
}
private bool ColumnEqual(object A, object B)
{

if (A == DBNull.Value && B == DBNull.Value)
return true;
if (A == DBNull.Value || B == DBNull.Value)
return false;
return (A.Equals(B));

}

__________________
S.Balasubramanian
Nothing is impossible