|
Provided by: Affinity IT Training, LLC ADO NET Using Visual C 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:C# .NET Application Developers seeking to integrate their applications with data sources.
|
|
||||||||||
ADO NET Using Visual C 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
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
Digging Deeper into Commands and DataReaders
Caching Data in DataSets
Populating a DataTable
Filling DataSets Using a DataAdapter
Using the Load Method
Retrieving Schema Information
DataSets and XML
Applying Constraints
Using Constraints
Foreign Key Constraints
Other Constraints
Data Relations
Creating DataRelations
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 a Strongly Typed DataSet
Using a Strongly Typed DataSet
Issues with Using a Strongly Typed DataSet
Handling Exceptions and Data Errors
Using Structured Exception Handling
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
Jan08
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
