Training Resources
Accessibility
Web Development
Adobe / Macromedia Web
Programming
Visual Studio 2005 (.NET 2.0):
VB.NET Application Development
ADO.NET Data
Programming in VB
C#.NET Application Development
ADO.NET Data
Programming in C#
Visual Studio 2008 (.NET 3.5):
VB.NET Application Development
C#.NET Application Development
What's New in VS2008
(2-day courses):
Databases
Professional Courses
Project Management
with
Microsoft Project
Managing Enterprise Projects
Using Project Server
Adobe
Microsoft SharePoint
Technical
Geographic (GIS)
ESRI ArcGIS 9.2:
ESRI ArcGIS 9.3:
Microsoft Office
Training Resources
ADO.NET Using Visual C# 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. We will also discuss how to leverage the power of XML through serialization, Diffgrams, and the XMLDataDocument object. ADO.NET features that support SQL Server 2005 technologies will be discussed, 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.
Course Topics:
(for a full detailed outline, visit our PDF link above)
Accessing Data with ADO.NET
- The ADO.NET Object Model
- Connecting to Data
- Understanding Connection Pooling
- Using Provider Statistics
Retrieving Data
- Introducing Command Classes
- Working with Data Readers
- Deeper into Commands and DataReaders
Caching Data in DataSets
- Populating a DataTable
- Filling DataSets
- Using DataAdapter and Load Method
- Retrieving Schema Information
- DataSets and XML
Applying Constraints
- Using Constraints
- Foreign Key Constraints and Other Constraints
Data Relations
- Creating DataRelations and Navigation Pathways
- Expressions and Relations
- Specifying XML Nesting
Updating Data
- Creating Commands with CommandBuilders
- Creating Custom Commands
- Using Stored Procedures
- Performing Batch Updates
Using Strongly Typed DataSet Classes
- Using a Loosely Typed DataSet
- Creating and Using a Strongly Typed DataSet
- Issues with Using a Strongly Typed DataSet
Handling Exceptions and Data Errors
- Using Structured Exception Handling
- Handling Provider Errors
- Transactions and Handling Concurrency Conflicts
Searching, Sorting, and Filtering
- The Sample Project
- Working with DataTables
- Working with DataViews
Handling AutoIncrement Columns
- The AutoIncrement Property
- Retrieving New Database Values
- Avoiding Multi-User Conflicts
- Merging Inserted Rows and Other Considerations
XML Techniques
- ADO.NET and XML
- Saving DataSet Data as XML
- Loading XML Data into a DataSet
- Working with XML Data in SQL Server
Features Supporting SQL Server 2005
- Enumerating Servers on a Network
- Asynchronous Processing
- Multiple Active Result Sets (MARS)
- Bulk Copy, User Defined Types, Snapshot Isolation
