Browse by Tags
All Tags »
Excel »
DataSets (
RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
More Posts
Next page »