ASP.NET - Find the duplicate records while uploading excel in asp.net

Asked By tousif khan on 10-Apr-13 12:16 AM
I want to restrict duplicates while uploading the excel data and to inform the user that the particular cell in excel contains duplicate value which is already exist in Sql Database.(Duplicates should be check in Excel (EMP_ID) against SQL (EMPLOYEE_ID).If duplicate record is found, Message should display as:"User cannot upload the data to with duplicate values. Kindly remove the duplicate fields and re-upload."