Home » Training Courses » Programming & Networking Training » ADO.NET Training

ADO.NET Training

2 days - please call for a quote

This ADO.net training course is designed to enable developers to use the toolset provided with Visual Basic .NET for data access including ADO.net objects, data controls, designers and interoperability with earlier ADO objects.

ADO.NET Course Objectives

During this ADO.NET training course delegates will:

Learn how to retrieve and manipulate data using Microsoft's new ADO.NET library.
Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet.
See how to apply constraints and relationships to disconnected data.
Learn how to update data, including how to handle stored procedures, parameters, and return values.
Understand how to search, sort, and filter data.
See how to leverage the power of XML.
Learn valuable techniques for building both Web and Windows applications.

ADO.NET Course Content

Introducing ADO.NET

Traditional Data Access Architecture
ADO.NET Disconnected Data Access Architecture
Different components of ADO.NE

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.NE
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

ADO.NET Training Course Prerequisites

For this ADO.NET course a knowledge of programming with a high level language and initial knowledge of Visual Basic .NET framework is required.

ADO.net Training Course Recommended Reading

Professional ADO.NET with VB.NET - Paul Dickinson, et al – buy from amazon
Microsoft ADO .NET (Core Reference) - D. Sceppa – buy from amazon

Download course outline as pdf.

+44 (0)1273 622272