Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet

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

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 >

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 ...

• Using A Single Transaction With Multiple Typed DataSets Provides a detailed explanation of how to implement a single transaction across multiple Typed Data ...

• Using Crystal Reports in ASP.Net Making use of strongly typed datasets Using Crystal Reports in ASP.Net Making use of strongly typed data ...

• Building an MVP Framework for .NET. Part 4: Strongly Typed Associations In this article we continue developing a Model-View-Presenter framework for .NET platform. The new features we are implementing here are strongly typed asscoiations between controllers, views and tasks for higher convenience and type saf ...

• Designing N-Tiered Data Access Layer Using Datasets - Part 4 Part of the business logic encapsulated in the Typed DataSet is the ability to add specialized queries to the table adapters to retrieve the data with different filters. By manipulating the XML schema that defines the dataset and adding the correct XML metadata, Visual Studio will generate the adde ...

• VB?s Statically Typed Wrapper for Dynamic Code Combining dynamic and static typing in VB ...

• Typed Dataset Linq Entities Converting Typed Dataset to and from Linq Enti ...

• ODP.NET - Retrieving Typed Data ODP.NET - Retrieving Typed Data While retrieving values from OracleDataReader, we can extract information available in individual columns (of a particular row) either by using column ordinal (position) values or column names. Visit http://www.exforsys.com to read complete article ...

• Article :: Working Capital and Cash Flow Analysis in Excel This chapter describes the process of accounting for and analyzing cash fl ...

• Export data to Excel using Dataset only Export data from Dataset to Excel without using Datagrid/DataT ...

Next: Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)