Font size:

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 C# 2010. 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: 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.

Learning Objectives
  • 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
Register Now
Viewing and Navigating Data with ADO.NET 4 DataSets Using C# 2010 Online course
  • Course ID:
    250150
  • Duration:
    90 minutes
  • Price:
    $75