point10.1.2007
PHP With MySQL Programming remains the #1 selling course of 2007!

point related info
point1.8.2007
PHP/MySQL course ends the year in dramatic fashion by outselling all other courses in the final quarter of 2006.

point related info
newsletter icon
Enter valid email address to
receive our monthly newsletter
Email:

Name:
spacer
 

Understanding ADO.NET: Level 1


Course Description:

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.


Course Duration: 3-days
more info
email:
name:
phone: - -
message:

Prerequisites and Assumptions:

The student should have a working knowledge of Microsoft Windows and basic programming concepts.

Recommended Follow-up/RelatedCourses

Introduction to ADO.NET

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

Connecting to Data Sources
  • Connection Objects
  • Opening Connections
  • Connection Pooling
  • Retrieving Schema Information
  • Saving Connection Strings

Retrieving Data
  • Introducing Command Classes
  • Working with DataReaders
  • Digging Deeper into Commands and DataReaders

Creating Data in DataSets
  • Introduction to DataSets
  • Populating a DataTable
  • Filling DataSets Using a DataAdapter
  • 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
  • Revisiting the DataForm Wizard

Updating Data
  • Creating Commands with CommandBuilders
  • Creating Commands
  • 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

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

   
php logomysql logo

home | training | courseware | consulting | mentoring
contact us | about us | clients | news | policies

Copyright © 2005 by Ambrose King Company. All rights reserved.