Updating ADO.NET DataSets with Visual Basic

Course details

ADO.NET DataSets allow developers to easily update and manage data sources using Visual Basic 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.

• 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