Over the past four installments in this article series we have: created a SQL Server database for our web application; created an ASP.NET web page that
enabled the visitor to upload an Excel spreadsheet and view its contents in a GridView; and created a Data Access Layer (DAL) using Typed DataSets
for accessing our application database. All that remains is to import the uploaded Excel spreadsheet's data into the application database.
In a perfect world, a user would carefully check the data in the Excel spreadsheet and cross-reference it with the data already existing in the application
database. But our users are humans and bound to err. Therefore, it behooves us to design the import functionality so that it can gracefully handle common
types of mistakes. We'll examine two such cases: preventing duplicate entries and ensuring that the imported data is in the appropriate format.
Read on to learn more!
Read More >