Getting Started with ADO.NET 4 DataSets Using C# New Horizons Lebanon
Price: TBA
  • Duration: 2 Hours

Course details

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 C# 2010, 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: 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 scenarios in which it's appropriate to use the disconnected access model in ADO.NET
  • 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
  • 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
  • create an untyped DataSet and DataTable structure
  • enforce and remove unique constraints
  • use a DataAdapter to fill a DataSet and enable results to be paged through
  • 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
  • create a typed DataSet
  • create and configure a TableAdapter
  • add a query to a TableAdapter
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 Software Development starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or