In my C# project I want to upload excelsheet and store it in DB. But in sql i set primary key for one field.. so if i upload 10 datas including duplicate values, its rejecting whole sheet. i need to upload all data's except primary key field. how can i?
<b>eg:</b>
Fields like Application no, Request type, Request name
i set primary key for Application no,
Excel sheet datas:
1. 1234 RiskEnvission LSB
2. 4567 RiskEnvission DES
3. 7865 RiskEnvission LSB
//4. 1234 RiskEnvission DES(except this field i need to upload above 3 data's)