Introducing ADO.Net

• Traditional Data Access Architecture
• ADO.Net Disconnected Data Access Architecture
• Different components of ADO.Net

A review of basic SQL queries

• SQL SELECT Statement
• SQL INSERT Statement
• SQL UPDATE Statement
• SQL DELETE Statement

Performing common data access tasks with ADO.Net

• Accessing Data using ADO.Net
• Defining the connection string
• Defining a Connection
• Defining the command or command string
• Defining the Data Adapter
• Creating and filling the DataSet

A Demonstration Application

• The Interface
• Loading the table
• Filling the controls on the Form
• Navigating through the records

Updating Data

• Steps for updating the table
• Building the Application
• Loading the table and displaying data in the form's controls
• Initialing Commands

• Adding Parameters to the commands
• The ToggleControls() method of our application
• Editing (or Updating) Records
• Event Handler for the Save Button
• Event Handler for the Cancel Button
• Inserting Records
• Deleting a Record

Using Stored Procedures with ADO.net

• Sample Stored Procedures
• UPDATE Stored Procedure
• INSERT Stored Procedure
• DELETE Stored Procedure
• SELECT Stored Procedure
• Using Stored Procedures with ADO.Net
• The modified InitializeCommands() method
• The modified Load Table button's event handler

Using Data Grid Control to View .Net data

• A Demonstration Application for Data Grid Control
• Second Demonstration - Using multiple related tables

Data Access in a Connected Environment

• Retrieving data using the SELECT command
• Updating Records using INSERT, UPDATE and DELETE commands