Microsoft

ADO.NET 2.0

Course Code: ADON      Days: 3
Show all Microsoft .NET Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
England
Somerset
Bath (BA1) 21/05/08 £ 995
Bath (BA1) 13/08/08 £ 995
Bath (BA1) 29/10/08 £ 995
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

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

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


How to make a booking for the ADON course

 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership