Section 7: C# and VB Project: TableAdapter Select and Insert Queries with Parameters

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 returned, and set our ExecuteMode to "Scalar" in our properties sheet.

• 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
• Section 7: TableAdapter Select and Insert Queries with Parameters

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

You may be learning ASP.net because you want to better yourself by learning a new technology. God has a care for you and your life and your career. Ask Him for help, and as long as you're within His will, He will bless you. He will help you learn. He will even help you find a career. Don't give up or be disheartened. Just ask Him and claim His promise below.

Ask and you will receive, and your joy will be complete. John 16:24

The prayer of a righteous man is powerful and effective. James 5:16

Therefore I tell you, whatever you ask for in prayer, believe that you have received it, and it will be yours. Mark 11:24

May your dreams be in ASP.NET!
Nannette Thacker