Updating ADO.NET DataSets with C# 2010

Target Audience
Expected Duration
Lesson Objectives
Course Number

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.

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)

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
  • Course Number: