Advanced ADO.NET Programming with VB.NET

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


To explain how to modify DataSet data, update data sources, read and write XML data sources, and interact with ADO.NET

Target Audience

Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths


Good knowledge of VB.NET, SQL, relational databases, and Visual Studio .NET

Expected Duration

265 min.

Course Objectives

Advanced ADO.NET Programming with VB.NET

  • describe the process of adding new rows to data tables and of deleting and modifying row values.
  • describe how to handle errors and events when modifying data and how to accept or reject changes to data.
  • add and then modify rows of data, handle any errors or events arising, and accept or reject changes.
  • view different rows depending on their RowState and sort rows based on their values.
  • discuss the issues surrounding the updating of data sources using ADO.NET’s disconnected strategy.
  • explain how to define and use transactions using ADO.NET code.
  • describe how to select modified rows, get changes to a DataSet, and merge changed data with a current DataSet.
  • describe how to update a data source and handle any subsequent update conflicts.
  • manage DataSet changes, update the data source, and handle conflicts.
  • explain how to read and write data from an XML data source to a DataSet and back.
  • describe the processing of DataSet data as hierarchical data using the parallel XMLDataDocument object.
  • import XML data into a DataSet, synchronize with an XMLDataDocument, and transform XML into HTML.
  • describe the differences between ADO and ADO.NET and give reasons for the changes.
  • use legacy ADO objects from .NET managed applications and transfer ADO RecordSets to DataSets in ADO.NET applications.