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)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)