Updating ADO.NET DataSets With Visual Basic 2008

This course is included in our On-demand training solution.


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.


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

120 min.

Course Objectives

Changing DataSets Using 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
  • Committing Changes to a DataSet using Visual Basic 2008

  • recognize how to commit or undo changes made to a DataSet
  • identify the code for filtering and merging DataTable changes
  • Updating DataSet Changes to a Data Source

  • 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
  • Updating a Data Source with Visual Basic 2008

    Managing Data Integrity using Visual Basic 2008

  • 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
  • Managing Data Concurrency Violations and Exceptions

    Updating ADO.NET DataSets