• Lesson 6 (CS 106)
  File I/O, Try-Catch (Page 381), & Custom Subs (Chapter 25)
  
  VB106 Zip file for study group

• Introduction to File I/O (Traditional Method)

Loading a List Box from a disk file.  Slides

Videos for the "traditional" method:
Part 1 Read from disk file
Part 2 Write to a disk file
Part 3 Structured Error Handlers & Custom Sub routines

• The TryParse Function
  Sample demo for TryParse function
   
• Introduction to File I/O (.Net Method)
  
  A simple file reader & writer
  File I/O Using Streams & Error Handling (video)
  
• File IO-1 (6/17/2010) we modified in class.
• Using Streamreader/writer (6/17/2010)

• Lesson 7 (CS 106)
  Custom Functions, Classes, & Menus (chapters 12, 17, 25 & 26)
  
  LastChance project (classes with properties 5/25/2010)

• Object-Oriented Programming Techniques
  
  Introduction to Functions Part 1 Video
  Functions Part 2 Video
   
• Building Your First Class Module  Video
  • Using Class Modules Project Part 1
  • Using Class Modules Project Part 2
  • Using Class Modules Part 3 (with properties)
  • Data Validation With Class!
  • Using the "Like" keyword to test strings

• Working With Subs demo from class
• Working with Functions demo from class
• Working with Classes demo from class
  
  Drop-Down Menus & Windows Dialog controls
  
• Using Classes part 3
• Validation with class
  

• Lesson 8 (CS 106)
  Using Multiple Forms,
  Custom Classes, & introduction to simple SQL
  database applications.

• Using Multiple Forms & 3-Tier Architecture
  
  Using Multiple Forms and Classes
  
  Ron's Auto Parts Project (Multiple forms & Three-Tier design without database)
  My Gear & Exit Icons for toolbars
  

• Lesson 12 (CS 205)
  MS ACCESS DATA BASES  Part I: USING WIZARDS
  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.
 

• Lesson 12 (Study Group Version)
  MS ACCESS DATA BASES Part I: USING WIZARDS
  

• Study Group Projects
  
• AccessSuperDemo(8/5/2010)
• AccessDB Steps 3, 4, & 5
• AccessDB Search records
• How to display images from DB (03 & 07 DB using the grid & details view)
• Aug. 12 Access demo with searching & confirm delete (VS2010)
  
• How to create a new query using the dataset designer (pdf)
  
  
• Using the ReportViewer Control (VS 2008)
• Introduction
• Creating the report
• Get the project here

• Lesson 13 (For Study Group)
  MS ACCESS DATA BASES Part II: ADO in code

• Working with Relational Databases Part II
  • Get my customers.mdb for this lesson
    
• Study Group Projects (Updated/modied from those below)
  • 1-My first ADO in code project (read db only)
• Get the version we created in class here (8/23/2010)
• 1-A OOP Version (custom grid formatting & ADO classes)
  • 8-30-2010 Version (OOP Classes)
• Creating a Custom .DLL for our Access ADO code!
  • Custom Access ADO solution (2 projects with database. Look at Readme file first!)

• Lessons 13 & 14 (CS 205)
  MS ACCESS DATA BASES Part II: ADO in code
  Chapter 16

• 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 15 (CS 205)
  SQL 2005/08 Express DATA BASES I (Using the ADO Objects & Wizards)
  Chapters 13 & 14

• My first SQL project using the VS Wizards
  
• 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
  My Train Store MDI with DB version

• Lesson 15 (For Study Group)
  MS SQL DATA BASES Part I: Using the Wizards
  
  • Customers-05 database for this lesson
  • Working with SSMSE 10/4/2010 Word Doc (Kessler)

• My first SQL project using the VS Wizards
  
• Option 1: DB is part of VS solution
  • Get our project
  • Get another version (two related tables) 10-4-2010
    
• Option 2: DB is attached to SQL instance on development machine.
  • Get our project
    
• Option 3: DB is attached to SQL instance on my hosting service production SQL machine.
  • Conn info screen shot
  • Complete conn string
  • Get our project
    
    
• Introduction to MDI Applications
  • Simple MDI application we built in class (1/10/2011)
  • MDI Database Applications
    My Train Store MDI with DB version