GeekArticles
Database
SQL ServerImporting 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 CommentFiled 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
Related Articles
• 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 ...
• 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
...