VB.NET Fundamentals Phase I � Paul Sheriff

• 1.0 Introduction to ADO.NET
• 1.1 What is .NET?
• 1.2 VB.NET Application Types
• 1.3 Windows Programming Overview

• 2.0 Introduction to VS.NET
• 2.1 The VS.NET Start Page
• 2.2 VS.NET Application Templates
• 2.3 VS.NET Productivity Features

• 3.0 Object Oriented Programming
• 3.1 Buzzwords
• 3.2 Classes and Objects
• 3.3 Properties, Modifiers, Methods, Namespaces and Events
• 3.4 Constructors and Destructors

• 4.0 Controls
• 4.1 Control Types
• 4.2 Forms and Controls
• 4.3 Control Properties
• 4.4 Radio Button, Check Box and Picture Box Controls

• 5.0 Forms
• 5.1 Forms and Control Events
• 5.2 Sample Applications

• 6.0 Variable Types
• 6.1 Assigning Values to Variable Types
• 6.2 Sample Applications

• 7.0 Mathematical and Relational Operators
• 7.1 Overview
• 7.2 Sample Application
• 7.3 Additional Math and Relational Operators
• 7.4 The Order of Precedence

VB.NET Fundamentals Phase II � Alison Balter

• 1.0 Flow Control and Logic Structures
• 1.1 If..Then
• 1.2 Select Case
• 1.3 Compiler Directives
• 1.4 Looping
• 1.5 With..End With

• 2.0 Methods
• 2.1 The VS.NET Start Page
• 2.2 VS.NET Application Templates
• 2.3 VS.NET Productivity Features
• 2.4 Functions
• 2.5 Parameters
• 2.6 Calling By Value Versus by Reference
• 2.7 Optional Arguments
• 2.8 Built-in Methods on Data Types

• 3.0 Arrays and Constants
• 3.1 Arrays
• 3.2 Using Arrays
• 3.3 Creating Your Own Arrays
• 3.4 Miscellaneous Array Topics
• 3.5 Multi-dimensional Arrays
• 3.6 Constants

• 4.0 Introduction to ADO.NET
• 4.1 Getting Started with ADO.NET
• 4.2 Benefits of ADO.NET

• 5.0 DataBinding on Windows Forms
• 5.1 ADO.NET Data Binding
• 5.2 Binding Data to a DataGrid
• 5.3 Working with Combo Boxes
• 5.4 Displaying Data Based on a Parameterized Query
• 5.5 Manually Binding Data
• 5.6 What�s Different from VB 6.0

VB.NET Fundamentals Phase III � Alison Balter

• 1.0 Creating Classes
• 1.1 Overview
• 1.2 Creating a Class
• 1.3 Creating Properties
• 1.4 Creating Methods
• 1.5 Passing Data to a Constructor
• 1.6 Namespace

• 2.0 The StringBuilder Class
• 2.1 Introduction to StringBuilder
• 2.2 Using the StringBuilder Class

• 3.0 The MessageBox Class
• 3.1 Working with MessageBox

• 4.0 Creating Dialog Forms
• 4.1 Creating Dialog Box Forms

• 5.0 Working with MDI Forms
• 5.1 MDI Overview
• 5.2 Creating an MDI Project
• 5.3 Creating Menus
• 5.4 Working with MDI Child Forms
• 5.5 Creating Popip Menus
• 5.6 Manipulating Menus at Runtime

• 6.0 Introduction to Web Forms
• 6.1 Overview of ASP.NET and Web Forms
• 6.2 Creating a Web Form

VB.NET Desktop Development Phase I � Bruce Jones

• 1.0 Debugger
• 1.1 Breakpoints and Stepping
• 1.2 Breakpoint Window
• 1.3 Setting the Next Statement and Watching Variables
• 1.4 Command Window, Call Stack and Other Misc. Windows
• 1.5 Debug Object

• 2.0 Exception Handling
• 2.1 No Exception Handling and Simple Exception Handling
• 2.2 Catching Specific Exceptions
• 2.3 Throwing Exceptions
• 2.4 The Finally Block
• 2.5 Inner Exceptions
• 2.6 Custom Exceptions

• 3.0 Collection Classes
• 3.1 Array Lists
• 3.2 Hasthtables
• 3.3 Queues and Stacks

VB.NET Desktop Development Phase II � Bruce Jones

• 1.0 Variables
• 1.1 Introduction to Data Types
• 1.2 Assigning Values to Variables

• 2.0 Data Type Conversations
• 2.1 Introduction to Option Strict
• 2.2 Implicit and Explicit Conversations
• 2.3 The C Family of Conversations
• 2.4 The C Type Command

• 3.0 Value and Reference Types
• 3.1 Creating Value and Reference Types
• 3.2 Passing Value and Reference Types
• 3.3 Strings � Both Value and Reference!

• 4.0 Arrays
• 4.1 Simple Arrays
• 4.2 Multidimensional Arrays
• 4.3 Jagged Arrays

VB.NET Desktop Development Phase III � Bruce Jones

• 1.0 Adding Events
• 1.1 Introduction
• 1.2 Multiple Event Handlers
• 1.3 The e Parameter

• 2.0 Working With Delegates
• 2.1 Simple Delegates
• 2.2 The Delegate Parameters
• 2.3 Event Like Delegates
• 2.4 Multi Cast Delegates

• 3.0 Working With Classes
• 3.1 Classes with Events
• 3.2 Multicast Classes
• 3.3 All Together Classes

• 4.0 Multithreaded Applications
• 4.1 The Timer
• 4.2 Sleep
• 4.3 Launching a Thread
• 4.4 The Slow Thread
• 4.5 The Call Back
• 4.6 Write After Write
• 4.7 Helpful VB.NET Tools for Threading

VB.NET Desktop Development Phase IV � Alison Balter

• 1.0 The Code Behind the Form
• 1.1 Switching from Code View to Object View
• 1.2 Namespaces
• 1.3 Code Outlining
• 1.4 The #Region Directive
• 1.5 Code Editing and Documentation

• 2.0 Configuring the IDE
• 2.1 Exploring the IDE Options

• 3.0 Automating Repetitive Tasks with Macros
• 3.1 Recording a Macro
• 3.2 Viewing a Recorded Macro
• 3.3 Editing a Macro
• 3.4 Running a Macro
• 3.5 Using the Macro Explorer
• 3.6 Exporting a Macro
• 3.7 Using the Macro IDE
• 3.8 Creating a Macro Project
• 3.9 Responding to IDE Events

VB.NET Desktop Development Phase V � Alison Balter

• 1.0 Creating Classes
• 1.1 Defining Classes
• 1.2 Encapsulation and Information Hiding
• 1.3 Adding Field and Property Members
• 1.4 Adding Methods to Classes
• 1.5 Adding Class Events
• 1.6 defining nested Classes
• 1.7 Creating Instances of a Class

• 2.0 Inheritance and Polymorphism
• 2.1 Inheritance Basics
• 2.2 What is Inheritance
• 2.3 Defining Classes that Must be Sub Classed
• 2.4 Defining classes that Cannot be Sub Classed
• 2.5 Polymorphism
• 2.6 Dynamic typecasting
• 2.7 Defining interfaces

• 3.0 Shared Members
• 3.1 Declaring Shared Fields
• 3.2 Defining Shared Properties
• 3.3 Using Shared Methods
• 3.4 Defining shared Constructors

VB.NET Database Development Phase I � Alison Balter

• 1.0 Working with the Visual Database Tools in .NET
• 1.1 Why this Learning Module is Important
• 1.2 Introduction to the Visual Studio.NET Database Tools
• 1.3 Using the Database Designer
• 1.4 Using the Query Designer
• 1.5 Using the SQL Editor
• 1.6 Using the Component Designer
• 1.7 Using the XML Designer

VB.NET Database Development Phase II � Alison Balter

• 1.0 Working with the Visual Database Tools in .NET
• 1.1 Why this Chapter is Important
• 1.2 Exploring the Benefits of ADO.NET
• 1.3 Getting to Know the ADO.NET Object Model
• 1.4 Getting to Know the System.Data Namespace
• 1.5 Working with the .NET Data Providers
• 1.6 Introducing the ADO.NET Connection Object
• 1.7 Introducing the ADO.NET Command Object
• 1.8 Introducing the ADO.NET DataAdapter Object
• 1.9 Introducing the ADO.NET DataSet Object
• 1.10 Introducing the ADO.NET DataTableObject
• 1.11 Introducing the ADO.NET DataView Ojbect
• 1.12 Introducing the ADO.NET DataReader Object
• 1.13 Editing Data with ADO.NET

VB.NET Database Development Phase III � Alison Balter

• 1.0 Working with Data Aware Controls
• 1.1 Why this Chapter is Important
• 1.2 Simple Data Binding
• 1.3 Complex Data Binding
• 1.4 The Data form Wizard
• 1.5 The Drop-down List Web Control
• 1.6 The CheckBoxList Web Control
• 1.7 The RadioButtonList Web Control
• 1.8 The ListBox Control
• 1.9 The DataGrid Control
• 1.10 The Repeater Web Control
• 1.11 The DataList Web Control
• 1.12 The ComboBox Windows Control
• 1.13 The CheckedListBox Windows Control

• 2.0 ADO.NET and Stored Procedures
• 2.1 Benefits of using Stored Procedures
• 2.2 Creating and Working with Stored Procedures in Visual Studio.NET
• 2.3 Using ADO.NET to Execute Stored Procedures
• 2.4 Using Stored Procedures to Retrieve Data
• 2.5 Using Stored Procedures to Modify Data

Database Development Phase IV � Alison Balter

• 1.0 Basics of Working with the DataGrid Control
• 1.1 Why This Chapter is Important
• 1.2 Benefits of the DataGrid Control
• 1.3 Loading the DataGrid Control with Data
• 1.4 DataGrid Control Properties
• 1.5 Formatting Data in a DataGrid Control
• 1.6 Working with Columns in a DataGrid Control
• 1.7 Enabling Paging on a DataGrid Control
• 1.8 Allowing the User to Select a Row on a DataGrid Control
• 1.9 Sorting Grid Columns

• 2.0 Expanding Your Knowledge of the DataGrid Control
• 2.1 Adding a Hyperlink Column
• 2.2 Allowing the user to Edit Data on a Detail Page
• 2.3 Allowing the User to Edit Data in the Grid
• 2.4 Adding a Template Column
• 2.5 Allowing the User to Add New Rows
• 2.6 Allowing the user to Delete Data

VB.NET Database Development Phase V � Alison Balter

• 1.0 Basics of Working with the DataGrid Control
• 1.1 Why This Section is Important
• 1.2 Working with the DataSource Property
• 1.3 Overview of the Repeater Control Templates
• 1.4 Adding the Item Template
• 1.5 Adding the HeaderTemplate and the FooterTemplate
• 1.6 Adding the AlteratingItem Template
• 1.7 Adding the SeparatorTemplate
• 1.8 Adding Hyperlinks and Other Embedded Controls
• 1.9 Working with the itemCommand Event Procedure

• 2.0 Expanding Your Knowledge of the DataGrid Control
• 2.1 Why This Section is Important
• 2.2 Working with the DataSource Property
• 2.3 Adding the itemTemplate
• 2.4 Adding the AlternatingItemTemplate
• 2.5 Adding the HeaderTemplate and the Footer Template
• 2.6 Adding the Selecteditem Template
• 2.7 Adding the Seperator Template
• 2.8 Adding the EdititemTemplate Section
• 2.9 Working with the DataList Control�s Properties
• 2.10 Adding Event Handling code

VB.NET Database Development Phase VI � Bruce Jones

• 1.0 Advanced Dataset Features
• 1.1 Adding Primary Keys to DataTables
• 1.2 Adding AutoIncrement Columns to Data Tables
• 1.3 Adding Constraints to DataTables
• 1.4 Adding Foreign Keys to DataTables
• 1.5 Establishing Relationships Between DataTables
• 1.6 Enforcing Referential integrity Between Data Tables
• 1.7 Using the DataTable Original, Current AND Proposed Values
• 1.8 Getting Only The Changed Rows From A Data Table
• 1.9 Using DataAdapters With CommandBuilders

• 2.0 Working With XML
• 2.1 XML Introduced
• 2.2 XML vs. HTML
• 2.3 How To Represent Related Data
• 2.4 Document Type Definition Files
• 2.5 XML Schema
• 2.6 XPath
• 2.7 XSLT Transformations

VB.NET Database Development Phase VII � Bruce Jones

• 1.0 ADO.NET and XML
• 1.1 Working With XML in Design View
• 1.2 Creating XML From DataSets
• 1.3 Reading XML Into A DataSet

• 2.0 Web Services
• 2.1 Create A Simple Web Service
• 2.2 Adding Parameters To The Web Service
• 2.3 Consuming A Web Service
• 2.4 Web Service Proxy Class
• 2.5 Web Services That Returns A DataSet
• 2.6 Consuming A DataSet to a WEB Service
• 2.7 Passing A DataSet To A Web Service
• 2.8 Web Service Security