|
This course 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. The course also describes how to create, read, and write XML data.
|
| Meet
The Certified Instructor:
|
Jeff Cook - MCT, MCSD, MCAD, MCP, A+ and MCDBA
|
Module 1 - Connecting to Databases and Reading Data
ADO.Net
Connect and Read Data Creating a Connection Demo - Creating and Using Connections/Commands Connection Events Connection Exceptions Connection Pooling Pool Settings Demo - Connection Pooling Module 1 Review
Module 2 - Querying and Updating Databases
ADO.Net Commands
Command Properties Command Methods Demo - Create Commands Bind Data to Control Demo - Binding Commands to Controls Pass Parameters to Command Parameter Properties Demo - Execute a Command with Parameters Server Explorer Demo - Using Server Explorer Module 2 Review
Module 3 - Transactional Operations
What is a Transaction?
Transaction Support Transaction Characteristics Managing Local Transactions Local Transaction Example Demo - Local Transaction Managing Distributed Transactions Create Transaction Demo - Use Distributed Transaction Isolation Isolation Levels Isolation Matrix Demo - Show Effects of Isolation Levels Lab Demonstration 1 Module 3 Review
Module 4 - Disconnected Operations
ADO.NET Disconnected Model Create DataSet Model Demo - Create a Dataset Special Columns Constraints and Relations Demo - Add Special (Nondata) Columns DataSet Relations Demo - Create Dataset Relation Demo - Use Relation to Access Child Records Data Adapter Loading and Saving Data in a DataSet Data Adapter Properties Demo - Create and Use Data Adapter Data Views Data View Properties Demo - Create and Use Data view Module 4 Review |
Module 5 - Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Disconnected Datasets
Untyped vs. Typed Datasets Tables in Typed Dataset Demo - Creating a Dataset and Datatable Retrieve Data from a DataTable DataTable Methods DataTable Properties Demo - Work with Datatable's Table Adapters Demo - Create Table adapter Lab Demonstration 2 Module 5 Review
Module 6 - XML Operations on Disconnected Data
XML and ADO.Net
Work with XML and DataSets Demo - Load a Dataset from XML Demo - Write XML from Dataset Diff Gram Demo - Show Results of Diff gram Module 6 Review
Module 7 - Reading and Writing XML Data
Serially Reading XML Data
Create XML Reader Sample XML Reader Demo - Create and Use XML reader Serially Writing XML Data Create XML Writer Sample XML writer Demo - Create and Use XML writer Module 7 Review
Module 8 - Processing XML Data by Using DOM
What Is DOM? Load an XML Document Demo - Create and Load XML Dom Object What Are DOM Trees? Dom Tree XML Nodes in a DOM Tree XML Collection Classes Demo - Use XML Dom Object by Navigating Nodes Lab Demonstration 3 Module 8 Review |
