CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2389 - Programming with Microsoft ADO.NET

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework.

Click here for a printer-friendly version of this page

This class is available as a self-learning class also. Please contact LRS Education for more information about E-Learning.

Prerequisites

Basic Understanding of relational database concepts and data query and modification experience; Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic

Detailed Class Syllabus

Data-Centric Applications and ADO.NET

Design of Data-Centric Applications

ADO.NET Architecture

ADO.NET and XML

Connecting to Data Sources

Choosing a .NET Data Provider

Defining a Connection

Managing a Connection

Handling Coonection Exceptions

Connection Pooling

Performing Connected Database Operations

Working in a Connected Environment

Building Command Objects

Executing Commands That Return a Single Value

Executing Commands That Return Rows

Executing Commands That Do Not Return Rows

Using Transactions

Building DataSets

Working in a Disconnected Environment

Building DataSets and DataTables

Binding and Saving a DataSet

Defining Data Relationships

Modifying Data in a DataTable

Sorting and Filtering

Reading and Writing XML with ADO.NET

Creating XSD Schemas

Loading Schemas and Data into DataSets

Writing XML from a DataSet

Building DataSets from Existing Data Sources

Configuring a DataAdapter to Retrieve Information

Populating a DataSet Using a DataAdapter

Configuring a DataAdapter to Update the Underlying Data Source

Persisting Changes to a Data Source

How to Handle Conflicts

Building and Consuming a Web Service That Uses ADO.NET

Building and Consuming a Web Service That Returns Data