Don't click on me...I can't even spell VB


This page is designed to support the ongoing SCC Programming Study Group. We meet for two hours a week in order to expand our knowledge of Windows, ASP, & Embedded programming. We want to learn it all! The lessons are a combination of those found in CS106, CS205, & CS206 and new ones we create together. As we progress, I will keep adding stuff from these classes as well as the advanced stuff we are learning.

Study Group sections now have a light yellow background to help you find our latest stuff!

Return to Main Menu 

Access Downloads:

SQL Downloads:

Resources:

________________________________

Network Programming

Robotics Remote Control Projects

Topic/Lesson

The Details

  • 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

  • Lesson 7 (CS 106)
    Custom Functions, Classes, & Menus (chapters 12, 17, 25 & 26)

    LastChance project (classes with properties 5/25/2010)

 

 

  • Lesson 8 (CS 106)
    Using Multiple Forms,
    Custom Classes, & introduction to simple SQL
    database applications.
  • Lesson 12 (CS 205)
    MS ACCESS DATA BASES  Part I: USING WIZARDS
    Chapters 13 & 14

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

 

Working With ADO Objects In Code (Access DB)
  • Lesson 13 (For Study Group)
    MS ACCESS DATA BASES Part II: ADO in code

  • 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!
Introduction to SQL Server & SQL Express
  • Lesson 15 (CS 205)
    SQL 2005/08 Express DATA BASES I (Using the ADO Objects & Wizards)
    Chapters 13 & 14
  • Lesson 16 (CS205)
    SQL 2005 Express DATA BASES II (ADO in Code with SQL 2005)
    Chapters 13 & 14

Too cool!

Copyright 2008-2011 Ronald P. Kessler, Ph.D.
All rights reserved.
Revised: Jan. 11, 2011