[RS.com] VTC - Microsoft ADO.NET

[Admin]

Presenter: Mark Long
SKU: 33480
ISBN: 1932072756
Release Date: 2004-02-20
Duration: 5 hrs / 67 tutorials

Format: 67 .mov files in bulk, + HTML Table of Contents


TABLE OF CONTENTS:

Course Introduction



Welcome (04:35)
Course Overview (05:28)
ADO.NET in Action-DataReader (06:33)
ADO.NET in Action-DataSet (05:16)



Overview of ADO.NET



ADO.NET Objectives (03:48)
.NET Data Providers (03:50)
Using Data Namespaces (06:27)


ADO.NET Objects



ADO.NET Object Model (04:04)
Objects/Methods/Properties (02:26)


Connecting To A Database



Opening A Database Connection (03:13)
Using Error Handling (04:55)
Connection Status (04:02)
Using Trusted Security (04:55)
Connection String Variables (04:16)
Connecting to Access (04:12)
Using UDL Files (05:04)
Provider Gotchas (03:02)
Connection Miscellaneous (06:08)



Executing Commands


SQLCommand Object (04:45)
OleDbCommand Object (05:25)
Single Value Queries (03:57)
Parameterized Queries pt. 1 (04:23)
Parameterized Queries pt. 2 (03:19)



Using Stored Procedures


What is a Stored Procedure? (03:44)
Creating Stored Procedures (04:38)
Calling Stored Procedures (04:04)
Creating Stored Procedures with Parameters (03:53)
Passing Parameters to Stored Processes (04:21)
Transactions pt. 1 (04:14)
Transactions pt. 2 (03:25)



DataReader


DataReader Basics (01:34)
Using a DataReader (04:35)
Multiple Result Sets in a DataReader (06:50)
Reading Schema from a DataReader (04:32)



DataAdapter


DataAdapter Basics (01:36)
Using the DataAdapter (06:00)
Inserting Data with CommandBuilder pt. 1 (05:19)
Inserting Data with CommandBuilder pt. 2 (03:06)
Updating Data with CommandBuilder (04:59)
Deleting Data with CommandBuilder (06:05)



DataSet


DataSet Basics (01:55)
Typed DataSets (07:28)
Creating a DataSet (02:43)
DataTables (05:31)
DataRows (04:09)
DataColumns (05:19)
DataViews (04:42)



Data Binding


What is Data Binding? (02:59)
Data Bound Textboxes (04:49)
Life without Cursors (02:39)
Navigating with Binding Objects pt. 1 (04:10)
Navigating with Binding Objects pt. 2 (05:31)
Navigating with Collections pt. 1 (05:20)
Navigating with Collections pt. 2 (03:32)
Complex Binding (07:08)



XML & ADO.NET


XML Basics (05:21)
XML Terminology (05:39)
XML and .NET (03:15)
Reading XML Data (04:10)
Putting XML in DataSets (03:07)
Writing XML from a DataSet (04:26)
Much More XML (01:33)



What About ADO?


Using ADO (03:05)



DataForm Wizard


DataForm Wizard Basics (07:00)
Best Use for DataForm Wizard (03:54)



Background Info


Data Access TLA's (03:54)



Credits


About the Author (01:22)

Download Link: 1 File, 77MB:

Code:

http://rapidshare.com/files/288153194/MS_ADO.NET.rar