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

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

In Building the Importer Web Page and Uploading the Excel Spreadsheet we created an interface for users to upload an Excel spreadsheet to the web server with the end goal being that a user could import the uploaded spreadsheet's data into the application database. Before importing the data, it would be prudent to display the contents of the uploaded Excel spreadsheet to give the user one last time to look over the data and verify that they want to import it. The contents of an Excel spreadsheet can be programmatically queried with code and syntax similar to that used when querying a "regular" database, like Microsoft SQL Server. In this article we will see how to bind the contents of the uploaded Excel spreadsheet to a GridView. 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 ...

• Working with XML Data Using LINQ, a TreeView, and a ListView :: Displaying Data With more and more data being stored in XML, web applications today commonly need some way to view and edit the data stored in an XML file from a web page interface. If the XML data is relatively "flat" and tabular in nature, we can use data Web controls like the DataGrid, GridView, and Repeater. ( ...

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

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