Posted on 2012-03-16
I have a aspx page which imports some data from excel sheet to database.
we validate excel sheet data to database. If any excel sheet data mismatch from database then java script confirm message box should come to tell data mismatch from database, do you want to proceed. if yes then data is inserted to database and if users click no then data is ignored.
Example : if we have 4 columns in sheet like FirstName,LastName,CountryName,StateName
and imports to database then CountryName,StateName is matched from the database if the CountryName and StateName is matched from the database then data is imported to Users Table and if there is some problem in data matching from the database then confirm message box should appear and if the user click yes then data is inserted to the database and if the users click no then data is inserted to the database.