ADO.NET

Silicon Beach Training Ltd.
Brighton, East Sussex, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' 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 Training 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 Training 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
...''

Elements of this syllabus are subject to change.

Phone:+44 (0)1273 622272

School Address/Venue(s):

86 Gloucester Road
Brighton
East Sussex
BN1 4AP
UK

Jobs & Resumes: Brighton
Houses & Roommates: Brighton

Search other schools for ADO.NET training resources.

Sage Line 50
VBA For Access
Access API
ACT
Publisher
FrontPage
Ruby on Rails
SQL
SQL Server
VB.NET
ASP.NET
CCNA
PHP
PHP MySQL
MySQL Database Administration
MySQL
ASP
VB Script
XML

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.