Find Duplicate records while uploading Excel file in asp.net?

Question

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 checked 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."

Is this possible if any idea can anyone please help me

vikasde · Accepted Answer · 2013-04-10 06:42:53Z

2

You should import the data using SQLBulkCopy into a staging table, the compare values using a join against SQL and return the duplicates back to the user so that he can fix them and re-upload the file.

answered Apr 10, 2013 at 6:42

vikasde

5,76110 gold badges48 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Find Duplicate records while uploading Excel file in asp.net?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related