I think the issue was by ths following , My problem was solved by just tweaking the process as per requirement. Now I just read the data from excel file and validate it like data type of the column should be correct so there should be no undefined value and then insert it into the database table and if there is any validation error I am showing user a message that Wrong input in the cell # of excel file.
On edit event how insert a value into the database in the same row as in the gridview?
By : GABRIEL ELIAS GUZMAN
Date : March 29 2020, 07:55 AM
With these it helps I have a gridview. Here are my columns: The column choose's control is a dropdown with 2 values: yes/no