Lessons

• Review Lesson
• 3-Tier design
• Classes & Properties (Chapter 11)
  • Access modifiers
  • Public, protected, shared, etc.

• Look at Lessons 7 & 8 on VB106 page
• The Ranch Market demo is a good overview of traditional & OOP styles
• Check out my 3-Tier model video series

• Lesson 9
  • MDI & Library Projects (Chapter 24)
  • .Net Threading Model
  • XML comments
    (Chapter 20)

• Introduction to MDI Applications
  
  MDI Demo (In and Out Project Revised)  Video
• VB205 Master MDI project (original version)
  
• Creating a Dynamic Link Library
  1. Make a project with validator class. Video
  2. Create a Class Library Project Video
  3. Add the new DLL to a new project Video
  
  Get the Class library project here
  Get the DLL demo project used in the video
  
• Creating Multi-threaded Applications
  • Overview of threads, processes, & application domains
  • Threading demo project
  • New Product: Visual Studio Async

• Lesson 10
  Collections & Custom Controls
• Chapters 4 & 8

• Collections
  Using For-Each Loops
  Controls Collection Demo

• Mid-Term Exam on
  Review lesson, 9 & 10

• Will be given on week 9
• Exam review guide

• Lesson 11
  Visual Studio LightSwitch 2011 (Requires VS2011 Sp-1)

• Introduction to LOB applications
  • Download VS LightSwitch here
  • Album Tracker
  • Aquarium store
    • Get fish database script here and unzip to c:\temp
    • To install DB: at command prompt type sqlcmd -S .\SQLEXPRESS -i "c:\temp\CreateAquarium.sql" then press ENTER.

• Lesson 12
  SQL 2008 Express DATA BASES I (Using the ADO Objects & Wizards)
  Chapters 13 & 14

• Lesson 13
  SQL 2008 Express DATA BASES II (ADO in Code with SQL 2008)
  Chapters 13 & 14

• My first SQL project using ADO in code
  ADO in code Part 1: Using a grid Video
  ADO in code Part 2: Add/Update/Delete Video

• Lesson 14
  
  Introduction to LINQ

• LINQ to SQL
  • 1-Writing our first LINQ Queries
  • 2- Reading From a Sorted List
  • 3- LINQ To SQL
  • 4- LINQ To SQL & Navigation
  • 5- Working With Related Tables

• Extra Stuff...
  

• How to send emails
  
• MapQuest Demo
  
• Trapping Keystrokes & how to make Enter work like Tab key
• How to play a video/music using the Media Player control
• How to Import Excel worksheet
• How to Export Excel worksheet
• How to use Resource Files in your projects
• Working with Groups & Lists of Data
  
  Data Arrays Part 1
  Data Arrays Part 2
  Data Arrays Part 3: Two dimensions

• ArrayList demo

• Working with Lists and the ListView Control

• Constructors & Overloaded Methods
  
  Creating our own constructors Pt. 1 Video
  Creating our own constructors Pt. 2 Video
  Using Overloaded Methods Pt. 3 Video
  (In this video I tell you MS used overloaded constructors. That is wrong, they used overloaded methods.)
  
  Get the Constructors project from these videos here