Lessons & Projects

Visual C# 2005 Version

• Lesson 1
  Introduction to Data Entry

• First Night Demo Project I showed in class.
• Data Entry Part 1
• Data Entry Part 2
  Learning C# Data Types (Slides) Chapter 4 in Murach)
  What are all those using statements for?

• Lesson 2
  Data Entry Parts 3 & 4

• Data Entry Part 3
• Data Entry Part 4
  Demo I showed in class

• Lesson 3
  Introduction To Variables, keystroke trapping, & Other cool stuff

• Introduction to Using Variables
• Using List Boxes & Dynamic Properties
• Learning about Running Totals & Counting
• Ron's Pet Store Demo (includes my images)
  
• Get ALL Lesson 3 projects here
• Trapping Keystrokes note: A KeyPress event can involve any printable keyboard character, the CTRL key combined with a character from the standard alphabet or one of a few special characters, and the ENTER or BACKSPACE key.
  
  Use KeyDown and KeyUp event procedures to handle any keystroke not recognized by KeyPress, such as function keys, editing keys, navigation keys, and any combinations of these with keyboard modifiers.

• Lesson 4
  Making Decisions (Chapter 5) & Custom Event Handlers

• IF and Select Statements

Making Decisions with If Statements  
Using If part 2
Using Switch

• Trapping Multiple Controls
  Using one event handler to trap three Radio Button click events
  
  
• Using Loops
  Loop Test Demo
  Using List boxes Part 1
  Using List boxes Part 2 
  Using List boxes Part 3 
  Data Validation Project
  
  For Each Loop Demo
  For Each Loop Demo Ver. 2
  
  Controls Collection Demo

• Lesson 5
  File I/O, Try-Catch, Custom Subs, & StreamReader/StreamWriter

• Introduction to File I/O (Page 700)
• Structured Error Handling (Page 180) Slides

Load List Box from a disk file project:
Using Stream Reader & Stream Writer

Videos:
Part 1 Read from disk file
Part 2 List box Add/Delete
Part 3 Write to a disk file

Stream Demo we did in class

• Lesson 6
  Custom Functions, Classes, & Menus

• Object-Oriented Programming Techniques
  
  Drop-Down Menus & Dialogs
  Introduction to Functions
  Using Class Modules Part 1
  Using Class Modules Part 2
   

• Lesson 7
  Using Multiple Forms

• Using Multiple Forms
  
  Ron's Auto Parts
   
• Introduction to Delegates
  
  Using C# Delegates

• Lesson 8
  MS ACCESS DATA BASES Part I (Chapters 17, 18 & 19)

• Working with Relational Databases Part I
  Get my database for lesson 8 & 9
  
  How to create an MS Access database videos.
  
  How ADO works with C# (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.

• Lesson 9
  MS ACCESS DATA BASES Part II: ADO in code

• Working with Relational Databases Part II

Get my database for lesson 9

ADO 2.0 in code (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.)

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

• Defining Reports
  
  Using the Report Viewer control project.
  Instructions only

MSDN Screen cast: The report Viewer Control

• Lesson 11
  SQL 2005 Express DATA BASES I (Using the ADO Objects & Wizards)

• My first SQL project
  Get my Database for this lesson(customers-05)
  
  How to create a SQL database video series.
  
   Data Sources, ADO & SQL  Documentation Only

• Lesson 12
  SQL 2005 Express DATA BASES II (ADO in Code with SQL 2005)

• My first SQL project using ADO in code
  Get my Database for this lesson(customers-05)

ADO in code using a grid control

• Lesson 13
  XNA Game Studio Express

• Learning to program Games
  • MoodLight Demo program
  • UFO Killer Part 1
  • UFO Killer Part 2 (no sound)

• Extra Projects
  Some useful projects.

• Web Browser Demo
• Notify icons and Google Search
• Using One event handler for multiple controls
• Using the Process component to launch browser.