Lesson

• Review Lesson
  3-Tier design, Classes, & properties

• 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 video series

• Lesson 9
  MDI Projects, Constructors, Overloaded Methods, & Inheritance

• Introduction to MDI Applications
  
  MDI Demo (In and Out Project Revised)  Video
  
• Constructors & Overloaded Methods
  
  Creating our own constructors Pt. 1 Video
  Creating our own constructors Pt. 2 Video
  Using Overloaded Methods Pt. 3 Video
  Using the Messagebox overloaded methods Video (In this video I tell you MS used overloaded constructors. That is wrong, they used overloaded methods.)
  
  Get the project from these videos here
  
• Introduction to Inheritance
  Class Inheritance Demo
  
  
• Creating a Dynamic Link Library
  1. Make a project that uses our library.  Video
  2. Create the Class Library Project Video
  3. Add the new DLL to your project Video
  
  Get the Class library project here
  Get the DLL demo project used in the video

• Lesson 10
  Arrays, Collections, Enumerations & Custom Controls (Chapters 4 & 8)

• Working with Groups & Lists of Data
  
  Data Arrays Part 1
  Data Arrays Part 2
  Data Arrays Part 3: Two dimensions
  
  Using For-Each Loops
  Controls Collection Demo

ArrayList demo

Working with Lists and the ListView Control

• Creating Custom Controls with Enumerations
  
  My RK_Textbox Control (Numbers, Letters, All)
  My RK_Masked Edit Control (Zip, Tele, SS#)
  My US States List Box Control (Dropdown with States abbreviations)
  Demo program that uses these three custom controls
  Get the DLL's only to add them to your toolbox

• Lesson 11
  Windows Dialogs, & Button Bar Control. Event Handlers Delegates, & Serialization

• Windows Dialogs, Menus, Printing, and Custom Event handlers

Ron's Text Editor (This shows context (popup menus also)

My icons for your menus (included in the project above also.)

• Introduction to Delegates
  Using VB Delegates
  
  
• Introduction to Serialization
  Introduction to XML serialization
  Introduction to Binary serialization
  

• Lesson 12
  MS ACCESS DATA BASES Part I
  Chapters 13 & 14

• Working with Relational Databases Part I
  Get my database for lesson 12
  
  How to create an MS Access database videos.
  
  How ADO works with VB & ASP.Net (Slides)
  
  Access Databases Steps 1 & 2: Using the new DataGridView Control
  (Step 1 displays data. Step 2 lets you edit Project has two forms)

Access Databases Step 3: Using textboxes and validation. (Step 3 shows a different way to manage data)

Access Databases Step 4 & 5

Access Databases Searching for records using the designer.

Working with Multiple Grids & Tables

• Lesson 13
  MS ACCESS DATA BASES Part II: ADO in code
  Chapter 16

• Working with Relational Databases Part II
  Get my database for lesson 13
   

ADO 2.0 Part II; Steps 1 & 2 (Step 1 displays data in a grid using code.

Step 2 lets you select/update/delete records. The project has 2 forms. The database & images are included.)

Step 2 also shows how to encrypt/decrypt your connection strings!

• Lesson 14
  MS ACCESS DATA BASES Part III: Reports Made Easy

• Defining Reports
  Get my database for lesson 14 (same as 13)
  
  Using the Report Viewer control project.
  Instructions only

MSDN Screen cast: The report Viewer Control

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

• My first SQL project using the VS Wizards
  
  MSDN SQL database video series.
  MSDN VB How to: Database Video Series
  Kessler's SQL DB Video Series
  
  ADO & SQL Wizards project.  Documentation Only
  
  Running SQL Aggregate Functions
  
  The Train Store: Multiple forms version
  
  The Train Store Demo with Report Viewer
  
  
• MDI Database Applications (Model for project 2)
  My Train Store MDI with DB version

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

• My first SQL project using ADO in code
  
  Get my Database for this lesson(customers-05)
  
  ADO in code Part 1: Using a grid control Video
  ADO in code Part 2 :Add/Update/Delete Video
  ADO in code Part 3: Using Custom Classes, Stored Procedures, Crystal Reports, & VS Report viewer!
  
  How to select data from related tables (Shows how to use two tables to get details view of customer orders)
   
• More complex database programming:
  
  ATM 3 DB version
  Working with Related tables & datasources

• Lesson 17
  Custom User Interfaces & ADO in Code for Access & SQL

• Creating a UI with your own Textboxes in Access
• Databinding Model
  Custom Databinding with Access  Get Access database
   
• Creating a UI with your own Textboxes in SQL 2005
  
  Custom Databinding with SQL 2005 (includes DB) Be sure to look at connection string in app.config file.

• Lesson 18
  Getting to know the SQL Command Object.

• Introduction to the SQL Command Object for connected environments
• SQL Command Object: How to execute SQL statements, Stored Procedures, Scalar commands, create a table, & save table data as XML.
  
• Using parameterized SQL queries

• Lesson 19
  VS 2008:
  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 Projects
  Enhanced controls and External programs.