My title may be wrong but I would like to explain this process that I need here,
Here is my Process,
I already have imported excel file and inserted it in the datatable, and then I also validated it's format before inserting it in the database.
Now Here is a process that i want to know,
In importing excel file, there could have been more than 1 error in a certain row or column, and I need to validate it, which I have already made, but I want that if there's an error in a single row, it will stop inserting the datas, even if there is a row that has no error, and then create a log report on all the rows which have errors.
What methodology should I use in that situation.
I have tried to loop the datatable of the imported excel, then validate it, but in it's validation method, if there is a correct row, it will automatically inserts it in the database, which must not happen unless all rows are really correct,
I really need help for this,