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

Author: aspnet.4guysfromrolla.com | Published: 5th Mar 2008 | Visited: 36 times | Add Comment
Filed in: SQL Server

This article is the second in a series of step-by-step tutorials by Nannette Thacker that show how to build an ASP.NET page to import an Excel spreadsheet into a database using Typed DataSets and TableAdapters. Last week's article, Building the Database, started with an overview of the system. We then created the ASP.NET website project, the database, and the two database tables, Members and Category. In this installment we will build the ASP.NET page for importing the Excel spreadsheet. This entails creating the page's user interface and file upload capabilities. At the conclusion of this article we will have created a page that enables users to upload their Excel spreadsheets. Read on to learn more! Read More >

Read Article

Sponsored Links

• Office Web Component v11.0 Spreadsheet And AJAX Interoperatibility Part 1 This article demonstrate, how OWC and AJAX can be used to store spreadsheet content as XML data into database.This XML in turns rendered as spreadsheet in OWC control from database sou ...

• .NET Building Blocks: Custom User Control Fundamentals Find out the gritty details required to create, test, use, inherit, install, and distribute .NET User Controls of all ty ...

• The Page Life Cycle of Client [Browser] Explained the client side page life cycle, ajax partial ren ...

• JavaScript Page Cookie (maintaining page state) Sometimes you need to redirect the user from the current page to accomplish a part of a task. Most people use pop-up windows to refrain from doing this, but sometimes you just can't do it any other ...

• Dynamically generating thumbnail images in ASP.NET with C# without affecting initial page load time Generate thumbnail on the fly without affecting page load ...

• Fast ASP.NET web page loading by downloading multiple javascripts after visible content and in batch Download all external scripts on your web page after the visible content is loaded for faster perceived speed and donwload multiple javascript in batch for better actual s ...

• Faster web page loading by defering and combining multiple external javascripts into one Download all external scripts on your web page after the visible content is loaded for faster perceived speed and donwload multiple javascript in batch for better actual s ...

• Taming Trees: Building Branching Structures Learn tree nomenclature and how to build binary trees that can recursively traverse and draw their own no ...

• Developing an ASP.NET page with MasterPage and Localization The MasterPage is derived from UserControl and thus, does not support the method 'InitializeCulture()'; a bit more coding is required in order to make the ASP.NET MasterPage localiza ...

• Building Interactive User Interfaces with Microsoft ASP.NET AJAX: Providing Visual Feedback with the... Microsoft's ASP.NET AJAX Framework helps page developers design more interactive web pages by streamlining the postback mechanism. In traditional web pages, a full postback involves the browser re-requesting the page, which is then re-rendered. This re-rendered page markup is returned, in its ...

Next: Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Database