Module 1 - Connecting to Databases and Reading DataADO.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 DatabasesADO.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 OperationsWhat 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 OperationsADO.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 WizardsDisconnected 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 DataXML 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 DataSerially 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 DOMWhat 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
|