ADO.NET Using VB.NET 2005

3 day course

In this course, you will learn about the features provided by ADO.NET 2.0.  You will learn how to connect to data sources, retrieve and manipulate data, and perform data updates; as well as examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, and DataRelation.  We will discuss how to apply constraints and relationships to disconnected data, and how to update data with stored procedures, parameters, and return values.  You will become familiar with the processes of searching, sorting, and filtering data stored in a DataSet or DataTable, and work with strongly typed DataSets.  You will learn how to leverage the power of XML through serialization, Diffgrams, and the XMLDataDocument object.  We will also discuss the ADO.NET features that support SQL Server 2005 technologies, along with asynchronous commands, Multiple Active Result Sets, bulk inserts , and more.  Further topics to be covered include how to connect to multiple types of data sources, retrieve data using the DataAdapter/Command/DataReader classes, create and configure Command parameters, cache data using the DataTable and DataSet classes, apply constraints to DataTable and DataColumn, and create relations using the DataRelation class.  You will also learn how to update data using DataAdapter and Command classes, use strongly typed DataSet and DataTable classes, retrieve and update data using TableAdapter classes, handle exceptions and data errors, search/sort/filter data using the DataView class, work with auto-increment columns in multi-user applications, and retrieve/generate XML data and take advantage of new SQL Server 2005 features.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• 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