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.

• Introduction: C# and VB Project: A Tutorial Using Data Sets, Table Adapters, WebForms, Controls, File Upload, Excel Import
• Section 1: Creating Our Project, Database and Tables
• Section 2: WebForm: Table, Label, and Panel Controls
• Section 3: FileUpload Control and Functionality
• Section 4: Auto Formatting a Web Form GridView
• Section 5: Bind the Excel Data to a GridView using an OleDbDataAdapter
• Section 6: Data Access Layer DataSet TableAdapters

Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip

Be careful of listening to, and being a gossip. You can bet that if they're gossiping about someone else, they're also gossiping about you. And if they're listening to you gossip, they're going to repeat it.

Do not let any unwholesome talk come out of your mouths, but only what is helpful for building others up according to their needs, that it may benefit those who listen. Ephesians 4:29

May your dreams be in ASP.NET!
Nannette Thacker