• Retrieve and manipulate data using Microsoft's ADO.NET library.
• Work with the ADO.NET object model.
• Apply constraints and relationships to disconnected data.
• Update data, including handling stored procedures, parameters, and return values.
• Search, sort, and filter data.
• Leverage the power of XML.
• Use valuable techniques for building both Web and Windows applications.

Duration: 2 days

>> Dates, prices & bookings for this course

>> Back to Programming courses overview

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.