ADO.NET Using C# / VB 2005

Thanks for your interest!

There are currently no dates scheduled for this course.

Please feel free to register your interest and we'll be sure to let you know once a date is available.

REGISTRATION OF INTEREST
   
Overview:
In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data stored in a DataSet or DataTable. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts , and more.
At Course Completion:
  • Connect to multiple types of data sources, including SQL Server and Microsoft Jet/Access
  • Retrieve data, using the DataAdapter, Command, and DataReader classes
  • Create and configure Command parameters
  • Cache data using the DataTable and DataSet classes
  • Apply constraints to DataTable and DataColumn objects
  • Create relations between DataTable objects, using the DataRelation class
  • Update data using DataAdapter and Command classes
  • Work with strongly typed DataSet and DataTable classes
  • Retrieve and update data using TableAdapter classes
  • Handle exceptions and data errors, including concurrency errors
  • Search, sort, and filter data using the DataView class
  • Work with auto-increment columns in multi-user applications
  • Retrieve and generate XML data

Show more

Outline:
Accessing Data with ADO.NET
Retrieving Data
Caching Data in DataSets
Applying Constraints
Data Relations
Updating Data
Using Strongly Typed DataSet Classes
Handling Exceptions and Data Errors
Searching, Sorting, and Filtering
Handling AutoIncrement Columns
XML Techniques
Features Supporting SQL Server 2005

 
CODE:0-0-NHAADONET
Choose your nearest New Horizons location below to view our EOCY offers:
BRISBANE MELBOURNE SYDNEY

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Career Opportunities

Copyright © 2015 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086