VTC - Microsoft ADO.NET

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 Download