• Microsoft Gold Certified Partner
  • Cisco Partner Learning Associate
  • Better Business Bureau

Questions? Call us at (919) 336-1000


2541 Core Data Access with Microsoft Visual Studio 2005 - Details

Return to All courses

Description:

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.

More Information  

Duration

3 days

Who Should Attend

This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

Prerequisites

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.

On Completion

After completing this workshop, students will be able to: - Connect to databases and read data. - Query and update databases by using commands. - Perform transactional operations. - Perform disconnected operations programmatically. - Perform disconnected operations by using Visual Studio 2005 wizards. - Perform XML operations on disconnected data. - Read and write XML data. - Process XML data by using the Document Object Model DOM.

Outline

Lesson 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?

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

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

Lesson 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?

Lesson 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

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

Lesson 7: Reading and Writing XML Data
The Process for Serially Reading XML Data
The Process for Serially Writing XML Data

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

Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.

Contact us to learn more about our courses and certifications.

Return to Top


News and Events

View all news

Top Certifications

"75 percent of managers believe that certified individuals are more productive and that certifications are important to team performance." - MCP Customer Satisfaction Study

Top Certifications in Information Technology Today

Why get certified? The importance of certifications. Read more...

 

What sets us apart

New Horizons Integrated Learning

For training to have a lasting and measurable impact, New Horizons understands that course content has to be designed and delivered in the context of our client’s specific environment and business need.  To achieve this, we blend custom content with leading edge and time honored training approaches, including Traditional Instructor-Led, Mentored Learning, Online Live, and Online Anytime, to meet the specific learning style of the individual and the complex learning objectives of the organization.

New Horizons Integrated Learning guides learners through all stages of the learning lifecycle. It consists of five components - AssessLearnReinforceSupport and Validate - to create the most effective learning experience available in the industry. 

Our Commitment, Guarantee and Promise