Learn how to develop using XML and ADO.NET.
Gain the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005 in this three-day instructor-led workshop. You will learn how to access and update data in a database by using ADO.NET, and you will learn to create, read, and write XML data.
Certification:
This course will help you prepare for the following certifications:
MCTS: .NET Framework 2.0 Windows Applications
MCPD: Windows Developer on Visual Studio 2005
MCPD: Enterprise Applications Developer on Visual Studio 2005
What You'll Learn
Connect to databases and read data
Query and update databases by using commands
Document Object Model DOM 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
Course Outline
1. Connecting to Databases and Reading Data
ADO.NET
Connecting to a Database and Reading Data
Connection Pooling
2. Querying and Updating Databases by Using Commands
ADO.NET Commands
Passing Parameters into Commands
3. Performing Transactional Operations
What a Transaction Is
Managing Local Transactions
Managing Distributed Transactions
Isolation Levels
4. Performing Disconnected Operations Programmatically
The ADO.NET Disconnected Model
Loading and Saving Data in a DataSet
DataViews
5. Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Comparing Untyped DataSets with Typed DataSets
Table Adapters
Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
6. Performing XML Operations on Disconnected Data
XML Representations of DataSets
DiffGrams
7. Reading and Writing XML Data
Serially Reading XML Data
Serially Writing XML Data
8. Processing XML Data by Using DOM
What DOM Is
DOM Trees
Types of XML Nodes in a DOM Tree
Labs
Lab 1: Connecting to Databases and Reading Data
Connecting to a Database
Saving a Connection String Securely in an Application Configuration File
Retrieving Data from a Database
Handling Connection Events and Exceptions
Configuring and Using Connection Pooling
Lab 2: Querying and Updating Databases by Using Commands
Creating and Running Query Commands
Creating and Running Parameterized Commands
Creating and Running Update Commands
Using Globalized Formats for Storing and Accessing Data
Lab 3: Performing Transactional Operations
Performing Data Updates within a Transaction
Choosing an Appropriate Isolation Level for a Transaction
Enlisting in a Distributed Transaction
Managing Transactions in the Data Tier
Lab 4: Performing Disconnected Operations Programmatically
Creating a DataSet Programmatically
Populating and Saving a DataSet
Adding, Modifying, and Deleting Data in a DataSet
Merging DataSets
Creating and Using DataViews
Lab 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Creating a Typed DataSet by Using the DataSet Designer
Loading, Displaying, and Saving Data in a Typed DataSet
Adding Code to a Typed DataSet
Creating a Typed DataSet by Using the Data Source Configuration Wizard
Adding Queries to a Table Adapter
Lab 6: Performing XML Operations on Disconnected Data
Saving a DataSet as XML Data
Loading a DataSet from XML
Saving and Loading DataSet Schema Information
Lab 7: Reading and Writing XML Data
Writing XML Data by Using XmlWriter
Reading XML Data by Using XmlReader
Lab 8: Processing XML Data by Using DOM
Reading XML Data by Using DOM
Writing XML Data by Using DOM
