Programming Training: 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

If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Visual Basic Training and bespoke Visual Basic courses

If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk

Programming Courses:ADO.NET using VB.NET Training Course

ADO.NET using VB.NET Course