In our final Section 9 of this tutorial by Nannette Thacker, we learn how to use our TableAdapters within our code. We also look at how Intellisense makes it easy to set up your TableAdapter code. Introduction: C# and VB Project: A Tutorial Using Data...
In Section 7 of this tutorial by Nannette Thacker, we learn how to create a select query statement in our table adapter and pass parameters to it. We learn how to create an insert query, use a "SELECT SCOPE_IDENTITY()" to retrieve the identity key value...
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...