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 C# 2005
with Ken Getz, Andy Baron

View the Course Outline

In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. More...

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

  • 10 modules of training
  • Over 15 hours of media run time
  • Over 600 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
ADO.NET Using Visual C# 2005
Format Sessions Retail Price


10 CD-ROMs

Buy Now!

CD-ROM & Books

10 CD-ROMs + Printed Books

Buy Now!



Buy Now!

DVD-ROM & Books

1 DVD-ROM + Printed Books

Buy Now!

Order online 

Read about Ken Getz, Andy Baron

Course Outline(Outlines are subject to change.)

ADO.NET Using Visual C# 2005

Sessions Run Time Pages
10 15 hours 600

In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. 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 stored in a DataSet or DataTable. 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. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts , and more.

In this course, you will learn to:

  • Connect to multiple types of data sources, including SQL Server and Microsoft Jet/Access
  • Retrieve data, using the DataAdapter, Command, and DataReader classes
  • Create and configure Command parameters
  • Cache data using the DataTable and DataSet classes
  • Apply constraints to DataTable and DataColumn objects
  • Create relations between DataTable objects, using the DataRelation class
  • Update data using DataAdapter and Command classes
  • Work with strongly typed DataSet and DataTable classes
  • Retrieve and update data using TableAdapter classes
  • Handle exceptions and data errors, including concurrency errors
  • Search, sort, and filter data using the DataView class
  • Work with auto-increment columns in multi-user applications
  • Retrieve and generate XML data
  • Take advantage of new SQL Server 2005 features
Accessing Data with ADO.NET

  • The ADO.NET Object Model
  • Connecting to Data
  • Understanding Connection Pooling
  • Using Provider Statistics

Retrieving Data

  • Introducing Command Classes
  • Working with Data Readers
  • Digging Deeper into Commands and DataReaders
  • Caching Data in DataSets

    • Populating a DataTable
    • Filling DataSets Using a DataAdapter
    • Using the Load Method
    • Retrieving Schema Information
    • DataSets and XML

    Applying Constraints

    • Using Constraints
    • Foreign Key Constraints
    • Other Constraints

    Data Relations

    • Creating DataRelations
    • Navigation Pathways
    • Expressions and Relations
    • Specifying XML Nesting

    Updating Data

    • Creating Commands with CommandBuilders
    • Creating Custom Commands
    • Using Stored Procedures
    • Performing Batch Updates

    Using Strongly Typed DataSet Classes

  • Using a Loosely Typed DataSet
  • Creating a Strongly Typed DataSet
  • Using a Strongly Typed DataSet
  • Issues with Using a Strongly Typed DataSet
  • Handling Exceptions and Data Errors

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

    Searching, Sorting, and Filtering

  • The Sample Project
  • Working with DataTables
  • Working with DataViews
  • Handling AutoIncrement Columns

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

    XML Techniques

  • ADO.NET and XML
  • Saving DataSet Data as XML
  • Loading XML Data into a DataSet
  • Working with DataSets and XML Together
  • Working with XML Data in SQL Server
  • Features Supporting SQL Server 2005

    • Enumerating Servers on a Network
    • Asynchronous Processing
    • Multiple Active Result Sets (MARS)
    • Bulk Copy Operations
    • SQL Server Max Data Types
    • SQL Server User Defined Types
    • SQL Server Snapshot Isolation

    back to top

    Your Instructor
    Ken Getz is a nationally renowned speaker and best-selling author who specializes in programming with Visual C# and Visual Basic. He is the author and presenter of some of most popular courses Ken is also a senior consultant with MCW Technologies and the author or co-author of several best-selling books including Access 2002 Developer's Handbooks (with Paul Litwin and Mike Gunderloy (Sybex)), Access Cookbook (with Andy Baron and Paul Litwin (O'Reilly)), VBA Developer's Handbook (with Mike Gilbert (Sybex)), and ASP.NET Developer's JumpStart (with Paul D. Sheriff (Addison-Wesley)). Since the inception of the program, Ken has been selected each year as a Microsoft Support MVP and is a member of the INETA speaker's bureau, traveling to speak at .NET user groups throughout the country. Ken is a frequent speaker at technical conferences, including Microsoft's Tech-Ed, as well as VSLive and DevConnections. Ken is also a technical editor for Advisor Guide to Microsoft Access and Advisor Guide to Microsoft Visual Basic and is a columnist for both CoDe Magazine and MSDN Magazine.

    Andy Baron, is a nationally recognized industry expert specializing in Visual Basic, Visual C#, ASP.NET, ADO.NET, SQL Server and SQL Server Business Intelligence. He has authored and presented more than 15 Visual Studio and SQL Server courses . Andy is also Senior Consultant with MCW Technologies, as well as a contributing editor for Advisor Media and Pinnacle Publications, a writer for SQL Server Magazine, and co-author of the Microsoft Access Developer's Guide to SQL Server. Since 1995, Andy has been selected each year as a Microsoft MVP for his contributions to Microsoft's online support. Andy also speaks regularly at industry conferences.

    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