Getting Started with DataSets using Visual Basic 2008

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


ADO.NET DataSet objects allow developers to utilize cached versions of data when working within disconnected data environments. This course examines the various aspects of DataSets and their role as one of the key components of the ADO.NET architecture. Specific topics covered include creating DataSets with Visual Basic 2008, working with typed and untyped DataSets, and configuring typed DataSets and DataAdapters.
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

ADO.NET DataSets

  • identify the scenarios in which it’s appropriate to use the disconnected access model in ADO.NET
  • Creating Untyped DataSets with Visual Basic 2008

  • recognize the code for creating a DataSet, adding a DataTable to it, and setting column properties
  • enforce and remove unique constraints for a column or an array of columns
  • Working with DataAdapters using Visual Basic 2008

  • recognize how to programmatically fill an existing DataTable using a DataAdapter
  • identify how to use a DataAdapter object to retrieve data
  • recognize the steps for using the Fill method of a DataAdapter to page through query results
  • Working with Untyped DataSets using Visual Basic 2008

    Configuring Typed DataSets and TableAdapters

  • recognize the steps for creating a typed DataSet
  • identify the steps for creating a TableAdapter, using the TableAdapter Configuration Wizard
  • recognize the different ways to create TableAdapters
  • recognize the steps for updating a TableAdapter
  • Configuring a Typed DataSet and TableAdapter