Overview/Description
ADO.NET DataSets allow developers to easily update and manage data sources using Visual Basic 2008. This course examines how DataSets are used to update source data and also how to manage the integrity of the data being updated. Specific topics covered include updating data sources, committing changes to data sources, managing data integrity, and how to deal with data concurrency violations and exceptions. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft .NET Framework 3.5, ADO.NET Application Development 70-561. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 3.5, ADO.NET Applications certification.

Target Audience
All organizations or individual consultants who are building or intend to build .NET Framework 3.5 applications with ADO.NET, Visual Studio 2008 and Visual Basic 2008; corporate employees, consultants, and university or college students who are preparing for the Technology Specialist (TS): Microsoft .NET Framework 3.5, ADO.NET Application Development 70-561.

Prerequisites
Thorough knowledge of software-development concepts and the process of building business applications; experience building data applications with the Microsoft .NET Framework; working experience of Visual Studio 2008, Visual Basic 2008, and ADO.NET 3.5.

Expected Duration (hours)
2.0

Lesson Objectives

Updating ADO.NET DataSets With Visual Basic 2008
# identify different ways of inserting data into DataSets
# identify the code for adding rows to DataSets
# recognize the steps for loading a DataTable with rows from a data source
# recognize the code for editing existing ADO.NET data
# recognize how to commit or undo changes made to a DataSet
# identify the code for filtering and merging DataTable changes
# recognize the code for updating content with a DataAdapter
# recognize the steps for updating content using a TableAdapter
# recognize the steps for updating a DataSet within a transaction
# change DataTable content
# filter and merge DataTable changes
# update changes to a data source
# recognize the steps for validating data during row and column changes
# identify the steps for handling DataTable errors
# recognize the steps for implementing concurrency
# recognize ways to handle update errors
# use row and column events to validate data
# handle DataTable errors in a given scenario
# handle update errors and exceptions using DataAdapter events
# update DataTable content