ADO NET Tutorial: (25 Hours) ADO.NET Step By Step Video Tutorial

A. Overview of ADO.NET, the data-access component of the Microsoft .NET Framework
B. How ADO.NET works with almost any component on nearly every platform that understands XML.

5/9/2007 Duration: 63 minutes

A. Creating Connections
B. Connection Properites
C. Methods for manipulating connections
D. Handling events raised by connections

5/16/2007 Duration: 53 minutes

A. DataReaderallows one to retrieve recordsets from databases
B. How to manipulate the data with commands (Select, Update, Delete, Insert)

5/23/2007 Duration: 65 minutes

A. How the DataAdapter facilitates the communication between the DataSet and the database. B. How the DataSet provides methods to select, insert, update, and delete data

5/30/2007 Duration: 64 minutes

A. Create a transaction
B. Create a nested transaction
C. Commit transactions
D. Rollback transactions

6/06/07 Duration: 53 minutes

A. Create DataSets
B. Add DataTables and DataRelations to DataSets
C. How to clone and copy DataSets.

6/13/2007 Duration: 57 minutes

A. Structure of DataTables
B. Properties of DataTables
C. Methods of DataTables.

6/20/2007 Duration: 58 minutes

A. How to build a TableAdapter class and a TableAdapter object, and how to configure them.

6/27/2007 Duration: 59 minutes

A. How the DataView can help you filter and sort DataRows at design time
B. How you can add a DataView to a form

7/05/2007 Duration: 55 minutes

A. Editing and updating data using DataViews, TableAdapters, DataTables, and DataSets.

7/11/2007 Duration: 65 minutes

A. Bind data to your Windows Forms
B. How to bind controls to ADO.NET data sources.
C.BindingSource class, new in ADO.NET version 2.0, which acts as an intermediary between a data source and Windows Forms controls to simplify and extend the data-binding process.

7/18/2007 Duration: 66 minutes

A. Binding data to format it
B. Displaying bound data
C. Data-Binding events

7/25/2007 Duration: 63 minutes

A. Binding data in Microsoft ASP.NET and Web Forms with ADO.NET objects
B. Data source controls, new to the Microsoft .NET Framework version 2.0, that enable data binding with very little code.

8/1/2007 Duration: 65 minutes

A. The data-bound Web Form controls that are designed to work with the Microsoft .NET version 2.0 data source controls that also work with ADO.NET objects.

8/08/2007 Duration: 63 minutes

A. Interaction between ADO.NET and XML.
B. Structure of an XML schema and the DataSet methods that enable us to read and write data from an XML data stream.
C. The XmlDataDocument that provides an XML view of the data in a DataSet.

9/05/2007 Duration: 70 minutes

A. Some real-world uses of ADO.NET.
B. How you can work with data objects created with previous versions of ActiveX Data Objects (ADO)
C. Microsoft ActiveX Data Objects Extensions for Data Definition Language (DDL) and Security (ADOX) library.

8/22/2007 Duration: 55 minutes