Updating ADO.NET DataSets with C# 2010

Overview/Description
ADO.NET DataSets allow developers to easily update and manage data sources using Visual C# 2010. 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: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner the MCTS: .NET Framework 4, Data Access certification.

Target Audience
All organizations or individual consultants who are building or intend to build .NET Framework 4 applications with ADO.NET, Visual Studio 2010 and Visual C# 2010; corporate employees, consultants, and university or college students who are preparing for the Technology Specialist (TS): Accessing Data with Microsoft .NET Framework 4 Exam 70-516.

Prerequisites
Thorough knowledge of software-development concepts and the process of building business applications; experience building applications with the Microsoft .NET Framework; working experience of Visual Studio 2010 and Visual C# 2010

Expected Duration (hours)
2.0

Lesson Objectives

Updating ADO.NET DataSets with C# 2010

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