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.

Your Instructor

Your instructors, Andy Baron, Mary Chipman, and Ken Getz are all Senior Consultants with MCW Technologies, a Microsoft Solution Provider. All have been Microsoft MVPs since 1995. When not creating applications for clients, Andy, Mary, and Ken write articles for technical journals such as MSDN, Visual Basic Programmer's Journal, asp.netPRO, Access-VB-SQL Advisor, MsOfficePro, and SQL Server Magazine, and have written over 10 technical books on various development topics. All three authors speak regularly at industry conferences, including Microsoft's Tech-Ed and DevDays, DevConnections, VBITS, and Advisor Devcon.

Course Ouline

SESSION 1
Introduction to ADO.NET

• 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

SESSION 7

Handling AutoIncrement Columns

• The AutoIncrement Property

• Retrieving New Database Values

• Avoiding Multi-User Conflicts

• Merging Inserted Rows

• Other Considerations

Migrating and Interoperability with ADO

• Migrating from ADO to ADO.NET

• Using ADO and COM Objects in .NET

• Consuming ADO Recordsets

SESSION 8

Migrating and Interoperability with ADO (continued)

• Consuming ADO Recordsets (continued)

• Call .NET Assemblies from Visual Basic 6.0

• Work with SQL-DMO

XML Techniques

• ADO.NET and XML

• Saving DataSet Data as XML

• Loading XML Data into a DataSet

• Working with DataSets and XML Together

SESSION 9

Windows Application Techniques

• 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

Web Application Techniques

• State Management

SESSION 10

Web Application Techniques (continued)

• State Management (continued)

• Caching Data in ASP.NET

• Data Binding

• Using Web Services