ADO.NET using VB.NET Course

This three-day, intensive course teaches the essential elements of ADO.NET such that, at the end of the course, the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting.

Target Audience: VB.NET .NET developers needing to communicate with datasources.

This course covers the subject areas covered in Microsoft Course MS2389.

SQL Programming, Fundamentals of XML and The .NET Framework Using VB.NET. The ability to write simple Windows Forms applications and a working knowledge of SQL Server Re recommended.

Topics covered on the 3 day ADO.NET using VB.NET course

Introduction to ADO.NET

• Mircrosoft Data Access Technologies
• From ADO to ADO.NET
• Namespaces and Classes
• Interfaces
• DataSets and Disconnected Access
• First ADO.NET Programs
• Acme Computer Case Study

ADO.NET Connections

• .NET Data Providers
• IdbConnection
• Connection Classes
• Connection Strings
• Connection Pooling
• Connection Events
• Error Handling

ADO.NET Commands

• IdbCommand
• Command Objects
• Creating Commands
• Executing Commands
• Parameterized Queries
• Command Types
• Using Stored Procedures
• Batch Queries

DataReaders and Connected Access

• DataReaders
• IDataReader
• IDataRecord
• Type-Safe Accesors
• Null Columns
• ExecuteReader Options
• Multiple Result Sets
• Obtaining Schema Information

DataSets and Disconnected Access

• DataSet
• DataAdapter
• Command Objects
• DataTable
• DataColumn
• DataRow
• Row States and Versions
• Accept or Reject Chnges
• DataTable Events
• Updating a Database from a DataSet
• Command Builders

More About DataSets

• Filtering DataTables
• Multiple Table DataSets
• Schema
• Constraints
• Relations
• Navigating a DataSet
• DataMapping
• Creating a DataSet Programmatically

XML and ADO.NET

• Strong Coupling Between ADO.NET and XML
• Rendering XML from a DataSet
• XML Schema and DataSets
• Typed DataSets
• Synchronizing DataSets and XML
• XML Serialization

Data Binding

• Data Binding in Windows Forms
• Simple Data Binding
• Complex Data Binding
• DataGrid Binding
• DataView
• Filtering and Sorting
• Data Binding in ASP.NET Web Forms

Concurrency and Transactions

• DataSets and Concurrency
• Optimistic Concurrency
• Handling Concurrency Violations
• ADO.NET Transactions
• Database Transactions