Instructor-led Classroom Learning - 3.00 Day(s)
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.
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
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
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