Viewing and Navigating Data with ADO.NET DataSets using Visual Basic 2008

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
The ability to view and navigate data in an efficient fashion is vital to any robust data application. This course explains how to accomplish this using ADO.NET DataSets and Visual Basic 2008. Specific topics covered include how to manage and constrain data relationships in a DataSet using DataRelation objects and ForeignKeyConstraints, and accessing and manipulating data using DataViews and the DataViewManager. 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.

Prerequisites
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 (hours)
1.5

Lesson Objectives

Viewing and Navigating Data with ADO.NET DataSets using Visual Basic 2008

identify the steps for adding a DataRelation object and specifying settings for the ForeignKeyConstraint object

recognize the uses of DataRelation objects

recognize the steps for navigating a DataRelation object

create a DataRelation object

apply foreign key constraint rules

navigate related DataTables

recognize the code for using a DataTableReader to iterate over result sets

recognize the code for using the Select and Find methods to access DataTable data

use the Compute method to perform an aggregate calculation on a subset of DataTable columns

identify the steps for creating a DataView

identify the appropriate method to use to view, access, or locate data in a DataView in a given scenario

recognize the code for editing a DataView

identify the steps for using a DataViewManager to apply default and custom settings to a number of DataViews

create a DataView

edit a DataView

configure DataView settings

Course Number:
sd_mand_a04_it_enus