ADO.NET

Course Overview

The course will provide a fundamental understanding of the ADO environment, a knowledge of the set of interacting objects, and the knowledge necessary to build data applications.

Audience

This course is intended for developers and others who need to use ADO.NET in building applications.

Prerequisites

Those attending should have a basic understanding of the .NET Framework and Microsoft Visual Studio 2005 and be competent in Microsoft Visual Basic. A basic understanding of relational databases and how they are structured and some knowledge of SQL syntax will be an advantage.

Course Outline

Getting Started with ADO.NET

• ADO.NET Object Model
• Creating a Simple Data-Bound Form
• Data Provider Objects

Using Connections

• Connections
• Configuring Connections
• Connection Methods

Data Commands and DataReaders

• Data Commands
• Command Methods
• DataReaders
• DataReader Methods

DataAdapters

• DataAdapters
• Configuring DataAdapters
• Using DataAdapter Methods
• DataAdapter Events

Transaction Processing in ADO.NET

• Transactions
• Using Transactions
• Creating Transactions
• Nested Transactions
• Commit and Roll Back Transactions

Modelling a Database, DataSets and DataRelations

• DataSets
• DataSet Methods
• DataRelations

Using DataTables

• DataTables
• DataColumns
• Constraints
• DataRows
• DataTable Methods
• DataRow Methods
• DataTable Events

Using TableAdapters

• TableAdapters
• Creating TableAdapters
• Configuring TableAdapters
• TableAdapter Methods

Using DataViews

• DataViews
• Creating DataViews
• Configuring DataViews
• DataView Methods

Editing and Updating Data

• Editing and Updating
• DataRowStates and Versions
• Editing Data in a DataSet
• Updating Data Sources
• Manual Data Binding in Windows Forms
• Data Binding in Windows Forms
• Binding Controls to ADO.NET Data Sources
• BindingContext Object
• CurrencyManager Object
• CurrencyManager Events
• Binding Object
• Configuring the Binding Object
• Binding Object Methods
• Binding Object Events

Data Binding in Windows Forms Using the BindingSource Component

• BindingSource
• Creating BindingSource Components
• Configuring BindingSource Components
• BindingSource Methods
• BindingSource Events

Using ADO.NET in Windows Forms

• Binding Navigator
• Displaying Data in Windows Controls
• Formatting Data
• Finding Data
• Validating Data in Windows Forms
• ErrorProvider Component

Basic Data Binding in Web Forms

• Data Binding in Web Forms
• Simple-Binding Web Controls to an ADO.NET Data Source
• Complex-Binding Web Controls
• ADO.NET Object State
• Navigation
• Updating an Underlying Data Source

Data Binding in Web Forms Using the Data Source Component

• Data Source Component
• Creating Data Source Components
• Configuring Data Source Controls
• Data Source Methods
• Data Source Events

Data-Bound and Validation Controls

• Data-Bound Controls
• List Controls
• Template-Based Controls
• DataControlFields
• Validation Controls

Reading and Writing XML

• XML Schemas
• ADO.NET and XML
• DataSet XML Methods
• Controlling XML Writing

The XmlDataDocument

• XmlDataDocument
• Creating XmlDataDocuments
• Navigating an XML Document
• XmlDataDocument Methods

ADO and ADOX in the .NET Framework

• COM Interoperability
• ADO in the .NET Framework
• ADO Objects
• ADO Recordsets
• ADOX in the .NET Framework