Module 1
ADO.NET Overview
ADO.NET Classes
OleDb vs. SQLClient
System.Data
ADO.NET Architecture
Presentation Tier
DataTable Object
Filling a DataTable

Connections & Commands
Connecting to a Data Source
Setting Up Connections
Making the Connections Commands
Command Objects
DataReader
SqlDataReader
Closing Connections

Working with Data
DataAdapter
Object DataSet
Object Filling a DataSet
OleDB
DataSet Iterate
Rows & Bind
Rows & Columns
Using SqlDataAdapter
Iterate Columns

ADO.NET Providers
Choosing a Provider
SQL Data Provider
OLE DB Provider ODBC
Data Provider
Multiple Providers
Using Interface
Inheritance
ReadData Procedure
Using IData Reader

Using COM Objects
How COM Works
.NET Advantages
CLR vs. COM Runtime
Callable Wrapper
Use VB6 COM Object

Exporting Data to Excel
Send Data to COM
Object Send Data to Excel
Release Excel COM
Object Explicitly
Declare & Release
Platform Invocation Services
Overview Create
Wrapper Class
Call Wrapper Class

Module 5
Crystal Reports Formulas
Customized Formula Behavior
Create Background Formula
Build Expression Review
Expression Apply Formula to Report
Calculated Fields
Format Calculated Field

Grouping & Totaling Reports
Group Options
View Grouped Report
Subtotals & Grand Total
Format Options
Filtering Reports
Programmatic Filtering

Windows Services Overview
Considerations Building Windows
Services Windows
Services Code
Services Properties
Build Service Installer
Install Service Test & Uninstall

Window Service Example
Overview Event Procedures
OnStart Event
Install Setup
Test Debug

Understanding XML Web Service
Web Service Requirements
Discovering Service Providers
Web Service
Web Service Code
Test Web Service

XML Web Service
Example Overview
Web Service Methods
GetAllInventory Method
GetInventory Method
WSDL Document
Namespace

Module 2
COM Callable
Wrapper Overview
Create COM Object
Set Properties
Calling .NET from VB6.0

Data Binding Basics
.NET Data Binding
Setting Up Data Source
DataAdaptor Wizard
Generating a DataSet
Bind DataGrid Control
Add Fill Method

Limiting Results
Query by Form
Generate SP DataAdaptor
Generate Categories
DataSet Bind & Fill ComboBox
Create Parameter
Query Select
ComboBox Categories

Data Navigation
Binding Context & Navigation
Set Properties
BindContext
Run Navigation Buttons
Binding Alternatives

Data Form Wizard
Overview Build Form from DataSet
Run & Load Form
Add & Bind Controls
Bind Control in Code Bind
Control to Controls

Review Classic ASP
Overview ASP Example
Data Access Code
ASP Object Model
View the Example
Handling ASP PostBacks
Mixing Code & HTML
Generated HTML

ASP vs. ASP.NET Overview
Loose Code & Collaboration
Difficulty Limited
Tools & Server Affinity
Obscure Configuration & PostBacks
Compiled Code & Code Separation
Cluster-friendly & XML-based Configuration
Automatic PostBack Handling

Creating ASP.NET App.
Create New Project
Web Form Layout
HTML View
Edit Control Properties
Code Window Edit
Code Test Application
Rendering HTML

Module 6
Web Service Clients
Web References
Web Reference Files
Reference.vb Calling Web Services
Retrieve Value
Retrieve DataSet

MS SOAP Toolkit
Consume Web Service
Set COM Reference Using SOAP
Call Web Service

Using UDDI Overview
Search UDDI Service
Add UDDI Reference
Implement Web Service

Binding to Views
Overview Binding
Context Adding Relationships
Binding to Relations

Formatting the DataGrid
Overview DataGrid
TableStyle Editor
Format DataGrid
DataGrid Format Properties

Restrict DataGrid Editing
Read-only Columns
Allow New
Edit & Delete Using DataViews

ListBox Controls Overview
Add Items to ListBox
Set ListBox
Focus Bind to an Array

Working with Images Overview
Populate ListBox
Remove Header Picture Box
Get Image
Insert Image
Cleanup Database

Code Access Security Overview
Code Based Security
Policy Levels
.NET Framework
Configuration Tool Runtime
Security Policy Evidence
The Stack Walk Permission Requests
How Managed Code Works

Implementing Permissions Requests
Declarative Security
Security Action
Embedded Attributes
Imperative Security

Module 3
Server Controls
Overview HTML Controls
Working with HTML Server Controls
Use ADO.NET to Retrieve Data
Hidden ViewState
Control HTML Table
Control Setting
HTML Properties

Using Web Controls Overview
Working with DataGrid Properties
Binding Data to a DataGrid Using Control Events
AutoPostBack
Client-side Code

Using DataSets
ADO.NET Object Model
Advantages XML Bridge
ASP.NET Using DataSet
Caching Data Changes
Accept & Reject Changes
Constraints in DataSets
Update Database

Creating DataSets
Code Overview
PageLoad Event
Fill Method
DataSet in Session
Retrieve DataSet
Add Constraints
Unique Constraints
Add Relations

Update with DataAdaptors
Command Builder
Get Commands
ASP.NET DataGrid
Custom Commands
Add Parameters
Source Version
Stored Procedures
Output Parameters

Module 7
Using Role-Based Security Overview
Principal Objects
Enabling Role Example
Add New Group
Security Implementation
Validate Identity Role
Setting Security Attributes
Permissions in Code

MDI Properties Overview
IsMdiContainer
IsMdiChild
Create MDI Parent
Coding MDI Forms

Menus in MDI Overview
Merging Menus MDI
List Properties
ActiveMdiChild Properties
MergeType & MergeOrder
MDI Child Code
Add Menus
Add Submenus
Cut, Copy & Paste Code

Microsoft MDI Sample Overview
MDI with Toolbar
Image Organization
Using MDI Toolbars
Image List Controls
Built-in Components
Serializable Classes
Graphical Procedures
Serialize & De-serialize

Graphic Manipulation Overview
Owner-Draw ComboBox
Owner-Draw Options
DrawItem Event
Draw ListItem
Using GDI+ Objects
Array List Drawing Item

Module 4
AutoIncrement
Column Properties
Value Conflicts
AutoIncrement Strategy

Transactional Model
ADO.NET Batch Process
BeginEdit & EndEdit
Explicit Transaction
DataRowVersion
RowState
GetChanges Method
AcceptChanges
RejectChanges

DataSets & XML
Data & Schema
File Creation
Create Nested XML
Open XML Schema
XML View Constraints
Open Nested Schema
Reading XML File
Implementing SML
Schema Readxml

Typed DataSets
Using Typed DataSets
Fill DataSet
View Typed Schema
Generate Typed DataSet
View Typed Objects
Working with Typed DataSet
Create Typed DataSet
Modify Fields
Define Relationship
Add Constraints
Saving Schema

Using Crystal Reports
Overview Report Layout
Report Issues
Setting Up Data
Create Report
View Expert Results

Modify Reports
Modify Fields
Format Objects
Format Sections
Setup to View
Report Load
Report View Report

Module 8
Drawing on Forms
Populate Lists
Reflection Assign Array
Create Graphics
Pass Parameters
Setup GDI+
Brush Object
Override on Paint

Transparency & Shaping Transparent Areas
Shaping Forms
Owner-Draw Menu
Menu Item Size
Draw Menu Item ME.
Transparency Key
Graphics Path
Regions & Opacity

Sample Deployment
Deploying Assemblies
Using ILDASM.EXE
Private & Shared Assemblies
Deployment Options

Windows Installer Deployment Overview
Create New Package
Select Files
Build MSI File
Install & Uninstall Registry & File Types
Editor Custom Actions
Replace MSI Files

Deploying to the GAC Versioning
Version Numbers
Assembly Cache
Viewer Using Strong Names
SN.EXE Sharing Components
Install Components in GAC
Add Merge Module Project

HTTP Deployment Overview
XCOPY Deployment
Security Setting
Run Deployed Application
Configure Evidence
Configure Assembly Trust