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
Human Test:
5 + 4 =
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