Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
ADO.NET Using Visual Studio .NET 2003
with Ken Getz, Andy Baron, & Mary Chipman


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

ADO.NET Using Visual Studio .NET
Format Sessions Retail Price

CD-ROM

10 CD-ROMs

$295
Buy Now!

CD-ROM & Books

10 CD-ROMs + Printed Books

395
Buy Now!

Course Outline(Outlines are subject to change.)

Microsoft ADO.NET

Sessions Run Time Pages
10 CDs 15 hours 800

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.

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

back to top


Your Instructor

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.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy