I am working in an MVC .net project. I use the below method to search for duplicate values in an excel sheet before uploading.
The dataset contains all the rows in the excel sheet. the colName is one of the columns in the excel sheet where the duplication is checked. the values in the particular are checked , iterated and if unique a copy stored in hashtable and the duplicate is stored in array list and the entire row containing the duplicate cell value is deleted.
"Here i only compare all the values in a single column of an excel sheet(colName). I would like to send two columns and compare a cell value in both the columns".
Can anybody help me.
public DataSet RemoveDuplicateRows(DataSet dSet, string colName)
Hashtable hTable = new Hashtable();
ArrayList duplicateList = new ArrayList();
foreach (DataRow drow in dSet.Tables.Rows)
View Complete Post