Good Day all, I am having little issue removing duplicate record
First I want to be able to compare the record from excel to that of the SQL, if the same, one will be deleted.. How do i please achieve that below is the code on how to import to sql using linq
try
{
string Pat = string.Concat(Server.MapPath("~/FileUpload/" + FileUpload1.FileName));
FileUpload1.SaveAs(Pat);
string PathToExcelFile = Pat;
var ExcelFile = new ExcelQueryFactory(PathToExcelFile);
ExcelFile.AddMapping<Question>(x => x.QuestionOrder, "QuestionNo");
ExcelFile.AddMapping<Question>(x => x.Title, "Question");
ExcelFile.AddMapping<Question>(x => x.Answer1, "A ...
Go to the complete details ...