View Course Outline

Learn how to manipulate relational data using Microsoft’s ADO.NET 1.1 library as you learn valuable techniques for building both Web and Windows applications!!

Course includes 45+ hours of total training time...

• 10 CDs
• Over 15 hours of media run time
• Over 800 pages of courseware on CD-ROM
• Step-by-step hands-on-labs
• Sample code

Microsoft ADO.NET

You will learn how to retrieve and manipulate data using Microsoft’s new ADO.NET library. Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data using Select, Find, and DataViews. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Understand migrating and interoperability issues with ADO as well as handling errors. Learn valuable techniques for building both Web and Windows applications.

• ADO.NET Code Created by Visual Studio
• The ADO.NET Object Model

Connecting to Data Sources

• Connection Objects
• Opening Connections

SESSION 2
Connecting to Data Sources (continued)

• Opening Connections (cont.)
• Connection Pooling
• Retrieving Schema Information
• Saving Connection Strings

Retrieving Data

• Introducing Command Classes
• Working with DataReaders

SESSION 3
Retrieving Data (continued)

• Digging Deeper into Commands and DataReaders

Caching Data in DataSets

• Introduction to DataSets
• Populating a DataTable
• Filling DataSets Using a DataAdapter
• Retrieving Schema Information
• DataSets and XML

Applying Constraints

• Using Constraints

SESSION 4
Applying Constraints (continued)

• Foreign Key Constraints
• Other Constraints

DataRelations

• Creating DataRelations
• Navigation Pathways
• Expressions and Relations
• Specifying XML Nesting
• Revisiting the DataForm Wizard

Updating Data

• Creating Commands with CommandBuilders
• Creating Commands

SESSION 5
Updating Data (continued)

• Using Stored Procedures
• Revisiting the Wizard Code

Using Strongly Typed DataSets

• Using Loosely Typed DataSets
• Creating a Strongly Typed DataSet
• Using Strongly Typed DataSets
• Issues with Strongly Typed DataSets
• Revisiting the Data Form Wizard

SESSION 6
Handling Exceptions and Data Errors

• Using Structured Exception Handling
• Handling Provider Errors
• Handling Concurrency Conflicts
• Using Transactions

Searching, Sorting, and Filtering

• The Sample Project
• Working with DataTables
• Working with DataViews

• The AutoIncrement Property
• Retrieving New Database Values
• Avoiding Multi-User Conflicts
• Merging Inserted Rows
• Other Considerations

• Migrating from ADO to ADO.NET
• Using ADO and COM Objects in .NET
• Consuming ADO Recordsets

Migrating and Interoperability with ADO (continued)

• Consuming ADO Recordsets (continued)
• Call .NET Assemblies from Visual Basic 6.0
• Work with SQL-DMO

• ADO.NET and XML
• Saving DataSet Data as XML
• Loading XML Data into a DataSet
• Working with DataSets and XML Together

• ADO.NET and Windows Applications
• Working with Data Binding
• Introducing BindingContext and CurrencyManager
• CurrencyManager Events
• Modifying Bound Data
• Working with DataGrid Controls
• More Databinding Issues

• State Management

• State Management (continued)
• Caching Data in ASP.NET
• Data Binding
• Using Web Services

back to top

Your Instructor

back to top