| Details: |
Training Course Outline
Session 1
Exception Handling Try/Catch Try/Catch/Finally Unhandled Exceptions Exception
Properties Multiple Exceptions SQL Multi-error Handling SQL Exception Informational
Messages , Concurrency Conflicts Blind Update Update Criteria Create SP Multiple
Entries , Concurrency Conflicts (cont.) RefreshData Method Save Changes Passing
Parameters Error Handling Stored Procedures , Transactions Isolation Levels
Error Detection Rollback Update Event Handler Declare/Commit Rollback Catch
ContinueUpdateOnError , Working with DataTables Search Methods Primary Key Multi-column
PK Dynamic Searches Wildcard Searches Delimiters Search w/Sort Row State , Sort/Filter
w/DataView Working with DataView Sort Data Filtering Data Filtering on Row State
RowStateFilter Iterating through Rows , Search/Edit w/DataView Finding a Row
Multiple Rows Modifying Data Adding a Row Modify Existing Row Delete a Row Total
Time: Minutes
Session 2
AutoIncrement Property Typed DataSet XML Schema Set In Method Missing Schema
Action AutoIncrement in Action , Retrieving DB Values Update Values Insert Value
Retrieve Increment Value UpdatedRow Source RowUpdated Event Data Adapter Event
Select @@Identity Generated ID Retrieval , Reset Identity Seed Delete/Purge
DBCC DBCC Check Ident Reseed Access/Jet DB Multi-user Issue , Avoiding Conflict
Multi-user Updates Seed and Step Successful Update , Merging Inserted Rows Problems
Solution Update Process Getchanges UpdateDataSource Skipping AcceptChanges Merge
Process Other Considerations , ADO to ADO.NET Upgrade Wizard Upgraded Application
Reference Libraries Troubleshoot Upgrade , Binding ADO Recordset Basic Concepts
Managed vs. Unmanaged Interop Assemblies ADO Recordsets Manual Fill Create Recordset
Use DataAdapter
Session 3
COM, ADO, and XML Working with COM Fill COM Component Working with XML Stream
ADO Recordset , Call .NET from COM COM Callable Wrapper Create COM Class Build
Type Library Call from VB 6.0 , Call SQL - DMO Working with SQL - DMO Set Reference
SQL Books Online Script Selected Table Create DataTable Retrieve Information
, XML Tools Overview Load XML File Data Tab XML Schema Read XML Data Write XML
Data , Saving Data as XML GetXML Method Output Options Mapping Type WriteXML
Method WriteXML w/Schema External Schema DiffGram Format Internal Schema , Load
XML Data Ground Rules Infer Schema Navigate DataGrid Internal Schema External
Schema ReadXML (DiffGram) XML String to DataSet , DataSets and XML Overview
XmlDataDocument Typed DataSet Manipulate Output Using XmlDataDocuments Format
with XSLT XSL Transform Object Query With XPath
Session 4
Data Binding Basics What is Data Binding? DataAdapter Bind DataSet Bind to Array
Generate DataSet Bind Controls to Data Adding Navigation , Currency Manager
Overview Binding Context Currency Manager Class Working with CM Single vs. Multiple
, Events & Bound Data Currency Manager Events Event Handling Forms Load Event
Modifying Data Add and Delete Submit Changes Handle Edit Modes , DataGrid Controls
Bind DataGrid Change Data Multiple Bindings Hierarchal DataSets Formatting DataGrids
, Databinding Issues Binding to DataView Set DataView Properties Multiple Forms
EditDetail Procedure Binding Object Events Binary Data Picture Box Control Insert
Binary Data , State Management Web Applications Classic ASP Threads/Cookies
Session ID Using Cookies Session Objects w/Cookie Session State Session State
in Action
Session 5
Storing ADO.NET Objects Storing Data Server Control Using ADO.NET Objects Using
Session State Fill Database Create/Save DataView Displaying Data Event Procedures
, Configure Session State Configuration Files Session State Options Out-of-Process
ASP.NET State Server Invoke Serialization Test State Server SQL Server Cookieless
State , Caching Data Application State ASP.NET Caching Cache Data Cache Methods
Cache Expiration Cache ADO.NET Data Remove/Expire Cached Item ViewState vs.
Caching , DataGrids Controls Load DataGrid Fill DataView Sort Procedure Bind
Grid to Data View DataGrid Properties Hyperlink Columns Query String , DataGrid
Events Page Event Sort Event Edit Event Update/Cancel Event , Repeater Control
Overview Construct Repeater Data Binding Data Binding Expression , Using Web
Services Advantages Create Web Service Web Method Test Web Service Web Reference
Call Web Service Type Definition Web Services in Action |
