Title Language  : 

Find a Course... Try for Free!

 

Microsoft ADO.NET Tutorials

Course Content
ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately, or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results can be presented to the database users in any number of ways. In this tutorial, Mark Long shows you, step by step, how to take advantage of ADO.NET’s functionality to enhance your network’s productivity. To get started today, simply click one of the movie topics below.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

«« Hide This
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)


Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft ADO.NET
Author: Mark Long
SKU: 33480
ISBN: 1932072756
Duration: 5 hrs / 67 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products