Microsoft ADO.NET using VB.NET

Show more Microsoft Training Courses

About this class

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.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

• VB.NET .NET developers needing to communicate with datasources.

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

What prerequisites are required

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.

Contents of this class

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

Microsoft ADO.NET using VB.NET / cm76215

(C) AquinasTraining.co.uk - Contact Us