GeekArticles 
Database SQL ServerImporting an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Database
Author: aspnet.4guysfromrolla.com |
Published: 27th Feb 2008 |
Visited: 50 times |
Add CommentFiled in: SQL Server
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 >
Read Article Sponsored Links
Related Articles
• Building a .NET Console Application for Scheduled Tasks This article walks you through the process of building a simple .NET command-line application that is designed to be scheduled to execute. The sample application will send an HTTP request to a web server and send the returned HTML as the body of an email message. Once the application is complete, ...
• Building a Visual Studio DebuggerVisualizer with a Custom Serializer For most any Serializeable object, making a DebuggerVisualizer is exceeding simple and examples abound. However, if you are trying to build a DebuggerVisualizer for an object which is not Serializable or takes too long to Serialize and Deserialize, things are not quite so simp ...
