Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Importer Web Page and Uploading the Excel Spreadsheet

By Nannette Thacker

In the second installment of this tutorial, we discuss how to build the ASP.NET page for importing the Excel spreadsheet. We will create the page's user interface and add file upload capabilities. A Zip file with the complete source code, Excel Spreadsheet, and SQL Server Database is available for download.

The article series hosted on 4guysfromrolla.com continues with Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Importer Web Page and Uploading the Excel Spreadsheet.

Download the Application in ZIP Format

May your dreams be in ASP.NET!

Nannette Thacker

1 Comment

  • Thanks for a very helpful article. I would like to add a confirmation button before the data is written to the database. In a WinForms app, I could use msgbox with a YesNo return. How would this be accomplished in a Web application? I have seen examples where a confirm message is tied to the button_click action. I would like to process a bit of code inside of a CASE Select routine before I launch a message. Is this possible?
    Regards,
    Dave

Comments have been disabled for this content.