+44 (0)1737 821590
Complete ADO.NET for developers  |    A 2 day   hands on   training course

ADO.NET training course description

This ADO.net training course is designed to enable developers to use the toolset provided with.NET for data access including ADO.net objects, data controls, designers and interoperability with earlier ADO objects. The course is applicable for those using C# or VB.NET with ADO.NET

What will you learn
  • Retrieve and manipulate data using Microsoft's ADO.NET library.
  • Work with the ADO.NET object model.
  • Update data, including handling stored procedures, parameters, and return value.
  • Search, sort and filter data.
  • Leverage the power of XML.
ADO.NET training course details

ADO.NET training course contents

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

  • 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.
    Initialising 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
  • Sample Stored Procedures.
    UPDATE Stored Procedure.
    INSERT Stored Procedure.
    DELETE Stored Procedure.
    SELECT Stored Procedure.
    Using Stored Procedures with ADO.Net.

Learning path



Based on overall ratings

J. S. - Framestore CFC

"Hard concepts were explained very simply."

D. M. - Paradigm

"I’ve found it very useful and the course was very well put together and delivered."

Training approach

This structured training course seeks to build upon workbook learning through the use of group exercises, dynamic discussion and individual tasks in order to deliver an engaging and interactive module that will ensure all candidates are able to transfer their new skills into the workplace.