ADO NET Using Visual Basic 2005

Training Provided by Affinity IT Training, LLC Learn about the features provided by ADO.NET 2.0 including connecting to data sources, the various ADO.NET classes, stored procedures, parameters, return values, 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 various means. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts, and more. Audience:Visual Basic .NET Application Developers seeking to integrate their applications with data sources.

ADO NET Using Visual Basic 2005

Objectives

• 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 errorsHandle 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
• Take advantage of new SQL Server 2005 features

Outline

Setup

• Internet Explorer 6 (or equivalent)
• Microsoft Visual Studio C# 2005 .NET
• Internet access preferred

Seminar Pre-Requisites

• Programming experience in a high-level language.
• Learning to Program in Visual C# 2005
• ASP .NET Using Visual C# 2005

Training Materials

• Course Workbook

About The Training Provider: Affinity IT Training, LLC