This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server™ 2000, and the Microsoft.NET Framework. |
| |
| Outline: | |
| Lesson 1: Data-Centric Applications and ADO.NET |
Design of Data-Centric Applications
ADO.NET Architecture
ADO.NET and XML | |
| Lesson 2: Connecting to Data Sources |
Choosing a .NET Data Provider
Defining a Connection
Managing a Connection
Handling Coonection Exceptions
Connection Pooling |
| Lesson 3: Performing Connected Database Operations |
Working in a Connected Environment
Building Command Objects
Executing Commands That Return a Single Value
Executing Commands That Return Rows
Executing Commands That Do Not Return Rows
Using Transactions |
| Lesson 4: Building DataSets |
Working in a Disconnected Environment
Building DataSets and DataTables
Binding and Saving a DataSet
Defining Data Relationships
Modifying Data in a DataTable
Sorting and Filtering |
| Lesson 5: Reading and Writing XML with ADO.NET |
Creating XSD Schemas
Loading Schemas and Data into DataSets
Writing XML from a DataSet | |
| Lesson 6: Building DataSets from Existing Data Sources |
Configuring a DataAdapter to Retrieve Information
Populating a DataSet Using a DataAdapter
Configuring a DataAdapter to Update the Underlying Data Source
Persisting Changes to a Data Source
How to Handle Conflicts |
| Lesson 7: Building and Consuming a Web Service That Uses ADO.NET |
| Building and Consuming a Web Service That Returns Data |
Add to favorites
Email this page
On-Site Training
Seminar
