ADO.net

3 Day Course
Code ADON

This course has been retired in favour of the Visual Studio 2008: ADO.Net 2008 course.

Modules

Hide all

Getting Started with ADO.NET (3 topics)

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

Using Connections (3 topics)

  • Connections
  • Configuring Connections
  • Connection Methods

Data Commands and DataReaders (5 topics)

  • Data Commands
  • Command Methods
  • DataReaders
  • DataReader Methods

DataAdapters (4 topics)

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

Transaction Processing in ADO.NET (5 topics)

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

Modelling a Database, DataSets and DataRelations (3 topics)

  • DataSets
  • DataSet Methods
  • DataRelations

Using DataTables (7 topics)

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

Using TableAdapters (4 topics)

  • TableAdapters
  • Creating TableAdapters
  • Configuring TableAdapters
  • TableAdapter Methods

Using DataViews (4 topics)

  • DataViews
  • Creating DataViews
  • Configuring DataViews
  • DataView Methods

Editing and Updating Data (14 topics)

  • 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 (5 topics)

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

Using ADO.NET in Windows Forms (6 topics)

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

Basic Data Binding in Web Forms (6 topics)

  • 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 (5 topics)

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

Data-Bound and Validation Controls (5 topics)

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

Reading and Writing XML (4 topics)

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

The XmlDataDocument (4 topics)

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

ADO and ADOX in the .NET Framework (5 topics)

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

Prerequisites

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

Sections