Microsoft ADO.NET Tutorials
Online Contents For This Title
We have made some of the video tutorials for Microsoft ADO.NET freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Title Description
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.
Choose your media type:
|
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) | |
This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.
Tutorial Information
| Title: | Microsoft ADO.NET |
| Author: | Mark Long |
| SKU: | 33480 |
| ISBN: | 1932072756 |
| Release Date: | 2004-02-20 |
| Duration: | 5 hrs / 67 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
Subscription / Purchase Information
This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.
Select Bandwidth
Now Shipping
Client Testimonials
I just completed the Visual Basic for Access 2002 and learned a great deal. I loved the trainer Mark Long and look forward to more of his classes....
Vicki Pempek
United States
View All Titles 
Email this Page
Send us Feedback
Purchase/Add to Cart