Viewing and Navigating Data with ADO.NET 4 DataSets using Visual Basic New Horizons Lebanon
Price: TBA
  • Duration: 2 Hours

Course details

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 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.

  • 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
Updated on 08 November, 2015

About New Horizons Lebanon

As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.

See all New Horizons Lebanon courses
Courses you can instantly connect with... Do an online course on Visual Basic starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or