learn something new
FIND A CLASS
Virtual Training Schedule
Map : Bloomington, IL
Map : Springfield, IL
Find a Class
> Class Summary
MS2541 - Core Data Access with Microsoft Visual Studio 2005
If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at
This 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.
Click here for a printer-friendly version of this page.
Aug 19, 2013 - Aug 21, 2013
Contact us for additional availability.
Before attending this workshop, students must: Be able to manage a solution environment using the Visual Studio 2005 integrated development environment IDE and tools Understand the .NET Framework 2.0 and the Common Language Runtime Be able to program an application using a .NET Framework 2.0 compliant language Know how to make assemblies available to other applications Have a good understanding of basic relational database concepts Be able to use basic SQL commands Have a good understanding of XML including XML declaration, elements, attributes, and namespaces Be able to explain XML schema concepts
Detailed Class Syllabus
Connecting to Databases and Reading Data
What Is ADO.NET?
The Process for Connecting to a Database and Reading Data
What Is Connection Pooling?
Lab 1: Connecting to Databases and Reading Data
Querying and Updating Databases by Using Commands
The Process for Passing Parameters into Commands
Lab 2: Querying and Updating Databases by Using Commands
Performing Transactional Operations
What Is a Transaction?
The Process for Managing Local Transactions
Lab 3: Performing Transactional Operations
Performing Disconnected Operations Programmatically
What Is the ADO.NET Disconnected Model?
The Process for Loading and Saving Data in a DataSet
What Are DataViews?
Lab 4: Performing Disconnected Operations Programmatically
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
Lab 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Performing XML Operations on Disconnected Data
XML Representations of DataSets
What Are DiffGrams?
Lab 6: Performing XML Operations on Disconnected Data
Reading and Writing XML Data
The Process for Serially Reading XML Data
The Process for Serially Writing XML Data
Lab 7: Reading and Writing XML Data
Processing XML Data by Using DOM
What Is DOM?
What Are DOM Trees?
Types of XML Nodes in a DOM Tree
Lab 8: Processing XML Data by Using DOM
Copyright © 1996 - 2013 Levi, Ray & Shoup, Inc. All rights reserved. |
Trademark Information and Legal Disclaimers