In most data-driven Web applications, users add data to the database by entering it through a web page. While this works well for most scenarios, there are times when the user has already collected the data to enter elsewhere, and having them tediously re-enter it through a web page is not only inefficient but prone to typos. In this multi-part series we will examine how to import data from a Microsoft Excel spreadsheet into a database from a web page. Specifically, we will build a tiered application architecture using Typed DataSets and TableAdapters. A ZIP file with the complete source code, Excel spreadsheet, and SQL Server Database is available for download at the end of this article. You may easily modify this tutorial to use an existing database as well.
This article and the subsequent installments have been written with step-by-step instructions and screen shots. If you are learning ASP.NET, please refrain from downloading the source code and plunking it into your project, as the best way to learn is to walk through the tutorial from scratch and do each step yourself. In this first installment we will discuss the purpose and architecture of the application and create the database tables. Read on to learn more!
Read on to learn more!
Read More >