Client Login
Username:
Password:
Forgot your password?
  Training - Core Data Access with Microsoft Visual Studio 2005 (2541)  
   
 

This three-day instructor-led workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET. The workshop also describes how to create, read, and write XML data.

Course Outline
Module 1: Connecting to Databases and Reading Data
  • What Is ADO.NET?
  • The Process for Connecting to a Database and Reading Data
  • What Is Connection Pooling?

Module 2: Querying and Updating Databases by Using Commands
  • ADO.NET Commands
  • The Process for Passing Parameters into Commands


Module 3: Performing Transactional Operations
  • What Is a Transaction?
  • The Process for Managing Local Transactions
  • The Process for Managing Distributed Transactions
  • Isolation Levels


Module 4: Performing Disconnected Operations Programmatically
  • What Is the ADO.NET Disconnected Model?
  • The Process for Loading and Saving Data in a DataSet
  • What Are DataViews?


Module 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
  • Comparing Untyped DataSets with Typed DataSets
  • What Are Table Adapters?
  • Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards


Module 6: Performing XML Operations on Disconnected Data
  • XML Representations of DataSets
  • What Are DiffGrams?


Module 7: Reading and Writing XML Data
  • The Process for Serially Reading XML Data
  • The Process for Serially Writing XML Data


Module 8: Processing XML Data by Using DOM
  • What Is DOM?
  • What Are DOM Trees?
  • Types of XML Nodes in a DOM Tree


 

If you are interested in securing one or more seats for this valuable training, please call (716) 886-1245 or click here to email us.

 

 
 
Scheduled Events
 
 
NEW! JUMPSTART: Training Workshops
Let BrightPlanIT help you jumpstart the implementation of your new technology and/or software with a custom Training Workshop. As you purchase new technology and software, BrightPlanIT can help you jumpstart the implementation with our training workshops. Learn More
 
Newsletter
  E-mail Address  
 
 
   
Search
   
   
Contact
 
United States Offices Canadian Office
   
Buffalo Office:
493 Delaware Ave
Buffalo, NY 14202

Amherst Office:
2810 Sweet Home Rd
Amherst, NY 14228
Mississauga Office:
5925 Airport Road
Suite 200
Mississauga, ON
L4V 1W1
   
P: (716) 886-1245
F: (716) 886-2192
P:(905) 405-6280
F:(905) 672-8630