This series provides a thorough examination of ADO.NET to connect and utilize databases within your .NET applications, including the Connection, Command, DataAdapter, DataReader, DataSet and much more.

This ship has sailed …

This webpage describes a single series/course, each course containing many screencast videos. HOWEVER …

This series/course has been removed from our collection, probably because we have updated it with a newer version.

Read why I decided to keep old pages like this around. Or better yet, visit the home page … its the best place to get started.

Videos available for this series:

1. SQL Data Connection Object

   The Data Connection is a lifeline between the Data Provider (in this case, SQL Server) and your .NET application. This video shows how to use many of the properties and methods, as well as the two events that are raised by the Connection object.

2. SQL Data Command Object

   The SQL Data Command object allows you to perform commands and request data from a data source. This video demonstrates many of the methods and properties of the Data Command object.

3. Using the Data Command’s Parameter Collection

   When using stored procedures, you will often make use of input and output parameters. To populate or read from the parameters, you will need to add items to the Parameters collection. This video shows several techniques of how to accomplish this.

4. Sql DataReader Object

   The SQL Data Reader is an object that allows you to read the data that is retrieved from a Data Command. It is refered to as a “fire-hose” connection, because you can only read in one direction (and can’t jump back and forth through the Data Reader as you would an array or collection). This video shows several techniques of how to retrieve values and metadata from the Data Reader.

5. SqlDataAdapter

   Since DataSets are completely disconnected from their data source, a special adapter is needed to resolve any changes made to the DataSet back to the original data source. The SqlDataAdapter knows how to resovlve Updates, Deletes and Inserts, and this video demonstrates how it works. Also shows the DataAdapter events that can be captured by your applications.

6. Using Access in ADO.NET

   Demonstrates how to connect to an Access database using ADO.NET and the Server Explorer, create a DataAdapter, DataSet and data bind.

7. Dataset Concepts

   This video is a slide show that explains many key concepts like the difference between strongly typed and untyped datasets, how a dataset is different from a datareader, the XML/Dataset connection and more.

8. Strongly Typed Datasets via DataAdapter

   Demonstrates how to create a strongly typed dataset using the “Generate Dataset” function of the DataAdapter

9. Strongly Typed Datasets via XML Schema Designer

   Demonstrates how to create a strongly typed dataset using the XML Schema Designer

10. Creating Untyped Datasets at Runtime

    Demonstrates how to create untyped datasets at runtime, including the creation of DataTables and DataColumns.

11. Creating Untyped Datasets using VS.NET Editors

    Demonstrates how to use the built in VS.NET Collection Editors to create untyped datasets

12. Understanding Concurrency

    This video explains what concurrency is, the difference between Optimistic and Pessimistic concurrency, and how Concurrency is supported in ADO.NET and VS.NET.

13. Optimistic Concurrency

    This video demonstrates Optimistic Concurrency … VB.NET and C# versions available. Uses ADO.NET’s RowUpdated event that fires when calling the DataAdapter.Update method. Shows how to set the RowError and Status (using UpdateStatus enum), and use the HasErrors property of the DataRow.

14. A “Home Grown” Pessimistic Concurrency Example

    This video demonstrates some of the pitfalls typically encountered when attempting to create a home-grown custom implementation of pessimistic concurrency.

15. Pessimistic Concurrency Using Transactions

    This video demonstrates the use of the ADO.NET Transaction object and its various IsolationLevels to implement pessimistic concurrency in your applications. Explains exclusive and shared locking, “dirty reads”, and more.

16. Persisting a Dataset to XML

    Persisting a Dataset to XML

17. Optimizing DataReader Data Access

    Optimizing DataReader Data Access

18. ADO.NET Connection Pooling

    ADO.NET Connection Pooling

19. Understanding DataRow States and Versions

    Understanding DataRow States and Versions

20. ADO.NET DataView

    ADO.NET DataView

21. DataColumns.Expression

    DataColumns.Expression