"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

2541 - Core Data Access with Microsoft Visual Studio 2005

This course 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.

 

2541 - Core Data Access with MS Visual Studio 2005 course offered by MasterGrade.

Who should attend?

This course 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.

2541- Core Data Access with Microsoft Visual Studio 2005

Before attending this course, students must have:

  • 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

Module 1: Connecting to Databases and Reading Data

  • ADO.Net
  • Connect and Read Data
  • Creating a Connection
  • Connection Events
  • Connection Exceptions
  • Connection Pooling
  • Pool Settings

Module 2: Querying and Updating Databases

  • ADO.Net Commands
  • Command Properties
  • Command Methods
  • Bind Data to Control
  • Pass Parameters to Command
  • Parameter Properties
  • Server Explorer

Module 3: Transactional Operations

  • What is a Transaction?
  • Transaction Support
  • Transaction Characteristics
  • Managing Local Transactions
  • Local Transaction Example
  • Managing Distributed Transactions
  • Create Transaction
  • Isolation
  • Isolation Levels
  • Isolation Matrix

Module 4: Disconnected Operations

  • ADO.NET Disconnected Model
  • Create DataSet Model
  • Special Columns
  • Constraints and Relations
  • DataSet Relations
  • Data Adapter
  • Loading and Saving Data in a DataSet
  • Data Adapter Properties
  • Data Views
  • Data View Properties

Module 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

  • Disconnected Datasets
  • Untyped vs. Typed Datasets
  • Tables in Typed Dataset
  • Retrieve Data from a DataTable
  • DataTable Methods
  • DataTable Properties
  • Table Adapters

Module 6: XML Operations on Disconnected Data

  • XML and ADO.Net
  • Work with XML and DataSets
  • Diff Gram

Module 7: Reading and Writing XML Data

  • Serially Reading XML Data
  • Create XML Reader
  • Sample XML Reader
  • Serially Writing XML Data
  • Create XML Writer
  • Sample XML writer

Module 8: Processing XML Data by Using DOM

  • What Is DOM?
  • Load an XML Document
  • What Are DOM Trees?
  • Dom Tree
  • XML Nodes in a DOM Tree
  • XML Collection Classes

Duration:

Learning Materials:

Prerequisites:

What course next:



3 Days

All included

Intro to Programming »

MCPD

MCTS SQL 2008 »


Get a Quote today »

 

Course Content
2541- Core Data Access with Microsoft Visual Studio 2005

  • Connecting to Databases and Reading Data
  • Querying and Updating Databases
  • Transactional Operations
  • Disconnected Operations
  • Performing Disconnected Operations by Using Visual Studio 2005 Wizards
  • XML Operations on Disconnected Data
  • Reading and Writing XML Data
  • Processing XML Data by Using DOM

 

Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.

Name

Email

Phone

Location

Message


Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

Shaun2.jpg
- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

zaheer1.jpg
- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

rene1.jpg
- René Leandro Borges

I enjoyed doing the course in my own time!

sadia.jpg
- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup

Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.