Contents tagged with Excel
-
Section 6: C# and VB Project: Data Access Layer DataSet TableAdapters
In Section 6 of this tutorial by Nannette Thacker, we learn how to retrieve data from an uploaded spreadsheet, and import it into a SQL Server database. We will create a Data Access Layer DataSet and some TableAdapters. We will learn how to add a data connection to our web.config. We will learn how to create SQL Statements in our TableAdapters and use the Query Builder.
-
Section 5: Bind the Excel Data to a GridView using an OleDbDataAdapter
In Section 5 of this tutorial by Nannette Thacker, we will learn how to create a connection to our Excel Spreadsheet using an OleDbConnection with a Microsoft.Jet.OLEDB Connection String. We will learn how to create a SELECT query to retrieve data from a given Excel worksheet using an OleDbCommand. We will populate and bind our data to our GridView using an OleDbDataAdapter and DataSet.
We will also look at using Server.MapPath to find a physical directory on the server. -
Section 4: Auto Formatting a Web Form GridView
In Section 4 of this tutorial by Nannette Thacker, we will learn how to add and Auto Format a GridView in our WebForm. We will also learn how to create and add a Cascading Style Sheet to our project.
We will learn more about the Design view, and look at applying a scheme via the AutoFormat functionality of the GridView. -
Section 3: FileUpload Control and Functionality
In Section 3 of this tutorial by Nannette Thacker, we are going to look at the "FileUpload" control. We will discuss how to set a Label text value and set Panel visibility from Codebehind. We will also learn how to use the Handles key word at the end of our procedure declarations to handle our Button Click events. We will also view a snippet of code that uses error handling through Try/Catch/Finally.
-
Section 2: WebForm: Table, Label, and Panel Controls
In Section 2 of this tutorial by Nannette Thacker, we learn how to work with our WebForm and define the properties of an ASP.NET Table control to layout our buttons. We will learn how to add controls for Buttons, Panels and Labels.
We will learn a little bit about the Design mode, by creating our Tables using the Design mode. -
Section 1: Creating Our Project, Database and Tables
In Section 1 of this tutorial by Nannette Thacker, we learn how to create a project and our SQL Server Database Tables using Visual Web Developer or Visual Studio 2005 or 2008. We will look at the design of our Excel Spreadsheet and create a new database and tables for our imported data.
We learn how to use the Solution Explorer (Solution Explorer in VWD and Server Explorer in Visual Studio), and use the Database Explorer. We learn how to add a table, set a primary key, and use the Identity Specifications property when creating a table column. -
C# and VB Project: A Tutorial Using Data Sets, Table Adapters, WebForms, Controls, File Upload, Excel Import
In this tutorial by Nannette Thacker, we will create a VB or C# project from scratch. We will create DataSets, TableAdapters, a WebForm and Controls, a File Upload, and import and view an Excel Spreadsheet, and more! We'll also learn about intellisense and other features of Visual Studio or Visual Web Developer. This project may be used in both VS or VWD 2005 or 2008. Zip files with the complete source code in either C# or VB, Excel Spreadsheet, and .mdf SQL Server Database is available for download. You may easily modify this tutorial to use an existing database as well.
I have written this tutorial with step by step instructions and screen shots on how to do each point. If you are learning ASP.NET, please don't simply download the source code and plunk it into your project, the best way to learn is to walk through the tutorial from scratch and do each step yourself. -
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet
By Nannette Thacker
In the final installment of this tutorial, we look at importing the uploaded Excel spreadsheet into the application database tables using the DAL.
The article series hosted on 4guysfromrolla.com continues with Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet.
Download the Application in ZIP Format -
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)
By Nannette Thacker
In the fourth installment of this tutorial, we create the Data Access Layer (DAL) used to communicate with the application database during the import process.
The article series hosted on 4guysfromrolla.com continues with Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL).
Download the Application in ZIP Format -
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Displaying the Uploaded Excel Spreadsheet
By Nannette Thacker
In the third installment of this tutorial, we discuss how to bind the contents of our uploaded Excel spreadsheet to our GridView. A Zip file with the complete source code, Excel Spreadsheet, and SQL Server Database is available for download.
The article series hosted on 4guysfromrolla.com continues with Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Displaying the Uploaded Excel Spreadsheet.
Download the Application in ZIP Format