ADO.NET (Program Details)
COURSE OUTLINE
Course Introduction
Welcome
Course Overview
Microsoft ADO.NET in Action-DataReader
ADO.NET in Action-DataSet
Overview of Microsoft ADO.NET
ADO.NET Objectives
.NET Data Providers
Using Data Namespaces
ADO.NET Objects
ADO.NET Object Model
Objects/Methods/Properties
Connecting To A Database with ADO .NET
Opening A Database Connection
Using Error Handling
Connection Status
Using Trusted Security
Connection String Variables
Connecting to Access
Using UDL Files
Provider Gotchas
Connection Miscellaneous
Executing Commands
SQLCommand Object Tutorials
OleDbCommand Object
Single Value Queries
Parameterized Queries Tutorials 1
Parameterized Queries pt. 2
Using Stored Procedures
What is a Stored Procedure?
Creating Stored Procedures
Calling Stored Procedures
Creating Stored Procedures with Parameters
Passing Parameters to Stored Processes
Transactions Tutorials 1
Transactions pt. 2
DataReader
DataReader Basics
Using a DataReader
Multiple Result Sets in a DataReader
Reading Schema from a DataReader
DataAdapter
DataAdapter Basics
Using the DataAdapter
Inserting Data with CommandBuilder Tutorials 1
Inserting Data with CommandBuilder pt. 2
Updating Data with CommandBuilder
Deleting Data with CommandBuilder
ADO.NET DataSets
DataSet Basics
Typed DataSets
Creating a DataSet Tutorials
DataTables
DataRows
DataColumns
DataViews
Data Binding
What is Data Binding?
Data Bound Textboxes
Life without Cursors
Navigating with Binding Objects Tutorials 1
Navigating with Binding Objects pt. 2
Navigating with Collections pt. 1
Navigating with Collections pt. 2
Complex Binding
XML & Microsoft ADO.NET
XML Basics
XML Terminology
XML and .NET
Reading XML Data
Putting XML in DataSets
Writing XML from a DataSet
Much More XML
What About ADO?
Using ADO
DataForm Wizard
DataForm Wizard Basics Tutorials
Best Use for DataForm Wizard
Background Info
Data Access TLA's
Credits
About the Author and this ADO .NET Training Course
Return To Main Product Page
Price: £119.00
(incl. VAT and Delivery)
for Single User Licence