New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

2389B Programming with Microsoft ADO.NET On-Site Training

This on-site training class is also available as Public Schedule Seminar.

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

Course Description/Agenda


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.

 
Outline:
Lesson 1: Data-Centric Applications and ADO.NET
Design of Data-Centric Applications
ADO.NET Architecture
ADO.NET and XML
Lesson 2: Connecting to Data Sources
Choosing a .NET Data Provider
Defining a Connection
Managing a Connection
Handling Coonection Exceptions
Connection Pooling
Lesson 3: 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
Lesson 4: 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
Lesson 5: Reading and Writing XML with ADO.NET
Creating XSD Schemas
Loading Schemas and Data into DataSets
Writing XML from a DataSet
Lesson 6: 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
Lesson 7: Building and Consuming a Web Service That Uses ADO.NET
Building and Consuming a Web Service That Returns Data

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

 
Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!