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 VB.net. A basic understanding of relational databases and how they are structured and some knowledge of SQL syntax will be an advantage. DURATION:   3 days. Hands on. OBJECTIVES:   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. COURSE CONTENT:   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 JS06/01