I have a requirement where i need to eliminate the duplicate from a List<hashtable>
The hashTable is a row of Data, for example if there are 500 records with around 10 fields, these 10 fields willl make a Key for hashtable and it's row data will hold in to Value.
and this row (hshtable) will be added to List, so at the end List will have 500 (hashtable) records.
i need to remove duplicates from this List<> based on certiain criterian,
How can i make this possible, please help me, i need a solution in 2 days, by monday evening i need to finish it off.
so thanks in advance
could any one suggest me any sample code
List<Hashtable> executeDedup(List<Hashtable> sourceData, List<string> uniqueFieldList, DedupRuleTypes dedupRuleType)
sourceData will have list of Hashtable<colname, colvalue> for each row of actual data
uniqueFieldList is a list of field/column names to identify a row as unique in dedup
DedupRuleTypes is enum with options - Keep First Record, Keep the most complete record