This course explains how to accomplish this using ADO.NET Data Sets and Visual Basic 2010. The ability to view and navigate data in an efficient fashion is vital to any robust data application. Specific topics covered include how to manage and constrain data relationships in a Data Set using Data Relation objects and Foreign Key Constraints, and accessing and manipulating data using Data views and the Data View Manager. 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 Data Relation object and specifying settings for the Foreign Key Constraint object
- Recognize the uses of Data Relation objects
- Recognize the steps for navigating a Data Relation object
- Create a Data Relation object
- Apply foreign key constraint rules
- Navigate related Data Tables
- Recognize the code for using a Data Table Reader to iterate over result sets
- Recognize the code for using the Select and Find methods to access Data Table data
- Use the Compute method to perform an aggregate calculation on a subset of Data Table columns
- Identify the steps for creating a Data View
- Identify the appropriate method to use to view, access, or locate data in a Data View in a given scenario
- Recognize the code for editing a Data View
- Identify the steps for using a Data View Manager to apply default and custom settings to a number of Data Views
- Create a Data View
- Edit a Data View
- Configure Data View settings
Twitter
Studied or Worked here? Share Your Review
Please do not post:
Thank you once again for doing your part to keep Edarabia the most trusted education source.