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

2541 Core Data Access with Microsoft Visual Studio 2005 On-Site Training

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

This workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005

Course Description/Agenda


This workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET.

Who Should Attend:
This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

At Course Completion:
After completing this workshop, students will be able to:

- Connect to databases and read data.

- Query and update databases by using commands.

- Perform transactional operations.

- Perform disconnected operations programmatically.

- Perform disconnected operations by using Visual Studio 2005 wizards.

- Perform XML operations on disconnected data.

- Read and write XML data.

- Process XML data by using the Document Object Model DOM.

 
Outline:
Lesson 1: Connecting to Databases and Reading Data
What Is ADO.NET?
The Process for Connecting to a Database and Reading Data
What Is Connection Pooling?
Lesson 2: Querying and Updating Databases by Using Commands
ADO.NET Commands
The Process for Passing Parameters into Commands
Lesson 3: Performing Transactional Operations
What Is a Transaction?
The Process for Managing Local Transactions
The Process for Managing Distributed Transactions
Isolation Levels
Lesson 4: Performing Disconnected Operations Programmatically
What Is the ADO.NET Disconnected Model?
The Process for Loading and Saving Data in a DataSet
What Are DataViews?
Lesson 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Comparing Untyped DataSets with Typed DataSets
What Are Table Adapters?
Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
Lesson 6: Performing XML Operations on Disconnected Data
XML Representations of DataSets
What Are DiffGrams?
Lesson 7: Reading and Writing XML Data
The Process for Serially Reading XML Data
The Process for Serially Writing XML Data
Lesson 8: Processing XML Data by Using DOM
What Is DOM?
What Are DOM Trees?
Types of XML Nodes in a DOM Tree

 

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!