About Course

These projects and walkthroughs are designed to get you to an intermediate level. They are for both Visual Basic and C# .NET programmers. The code for both languages is included. Because VB and C# are both NET languages, the coding is not that different and you’ll be able to pick up a second language without any problems.

You don’t need to tackle the projects in any particular order. Just do the ones that take your fancy. The final project, the Stick Figure Cartoon app, will give you skills in completing a full program. It’s quite long, so don’t expect to finish it in one sitting! Good luck.

Instructor: John Sagimo

Course Content

Project One – Image Manipulation
A gentle introduction to manipulating images.

Session1: Rotate an Image in VB NET and C#
Session2: Flip an Image in C# or VB Net
Session3: Clone Image
Session4: Image Pixels in VB Net and C#
Session5: Invert Image Pixels
Session6: Saving an Image

Project Two – Image Information
How to get information endcoded in an image

Project Three – Using the Graphics object to draw

Project Four -An SQL Server Databases Project

Session1: Creating the Visual Studio Database Project
Session2: Creating the First Sql Server Database Table
Session3: The Second Database Table – Foreign Keys
Session4: Adding Data to the Two Tables
Session5: SQL Queries, Joins, Stored Procedures
Session6: Using Sql Parameters in Stored Procedures
Session7: Designing the User Form with a Data Grid
Session8: Writing the code for the Stored Procedure
Session9: Stored Procedures and Parameters
Session10: Create a Stored Procedure to Update a Table
Session11: Coding for the Update

Walkthrough 1: Code your own Email Client
Learn how to send and receive emails using VB and C# code

Step1: Design a User Form for an Email Client
Step2: The Smtp Client
Step3: New Mail Message
Step4: Email Attachments in .NET
Step5: POP3 Servers and Commands
Step6: Contacting the POP3 Server
Step7: POP3 Server Authentication
Step8: Do you have eMail?
Step9: Getting a List of Messages
Step10: Getting the Email
Step11; Parsing the Email
Step12: Deleting Emails from the Server

Walkthrough 2: Code your own Picture Viewer

Walkthrough 3: Excel Data and Charts Project
Create charts in VB and C# using data pulled from Excel

Step1: Introduction to the Project
Step2: The Chart Project Form
Step3: Connecting to Excel
Step4: Working with Excel Ranges in C# and VB Net
Step5: The ComboBox and Selecting Items
Step6: Creating a Chart from the Excel Data
Step7: The X Axis
Step8: Lines and Markers
Step9: Backgrounds, Titles, Rounded Corners

Walkthrough 4: Write a Text to Speech Program
Write an app that speaks! Read Text Files, PDFs, Word Docs, Web Pages

Step1: Intro to the Text to Speech Project
Step2: Designing the Form
Step3: Load Voices
Step4: Coding for the Speak Button using the SpeechSynthesizer Class
Step5: Pause, Resume, Stop
Step6: Which File Type was Opened?
Step7: Speech and Text Files
Step8: Open PDF and Get the Text
Step9: Open a Microsoft Word File with Code
Step10: Pronounce Highlighted Word
Step11: Get Text from URL

Walkthrough 5: A Stick Figure Cartoon App
Full program walkthrough! (Includes lesson on Version Control)

Step1: Create your own Stick Figure Cartoon Program – Introduction
Step2: Starting the Form Design
Step3: Adding the Buttons to the Form
Step4: TrackBars, Line Styles
Step5: Version Control in Visual Studio
Step6: Git Version Control, Branches
Step7: Git Commit Changes
Step8: Loading a Combo Box with System Colors
Step9: Setting up a Drawing Pen
Step10: Mouse X, Y
Step11: Bitmap and Graphics Objects
Step12: Stick Figure Dimensions
Step13: Stick Figure Head and Body
Step14: Drawing the Legs
Step15: Drawing the arms
Step16: Undo and Redo
Step17: Draw Stick Figure Female
Step18: Stick Figure Woman – Arms and Legs
Step19: Font Dialog Form
Step20: Launch Form on Right-Click
Step21: OK and Cancel Buttons
Step21: Load Sytem Fonts, Font Size
Step22: Adding the Text to the Picture Box
Step23: Save the Image
Step24: The Clear Button

About Course

Course Content

Project One – Image Manipulation A gentle introduction to manipulating images.

Session1: Rotate an Image in VB NET and C#

Session2: Flip an Image in C# or VB Net

Session3: Clone Image

Session4: Image Pixels in VB Net and C#

Session5: Invert Image Pixels

Session6: Saving an Image

Project Two – Image Information How to get information endcoded in an image

Session1: Intro and Form Design

Session2: Detecting the image type

Session3: Image Width, Height, Resolution, Pixel Depth

Session4: Image Metadata

Session5: Date and Time Photo was Taken, Enumerations

Session6: Adding Windows Forms Controls at Run Time

Session7: Get Image Colors

Project Three – Using the Graphics object to draw

Session1: Draw a Line on a User Form

Session2: The Paint Event

Session3: Drawing Rectangles

Session4: How to Draw an Ellipse with Code

Session5: Drawing Polygons

Session6: Drawing Text

Project Four -An SQL Server Databases Project

Session1: Creating the Visual Studio Database Project

Session2: Creating the First Sql Server Database Table

Session3: The Second Database Table – Foreign Keys

Session4: Adding Data to the Two Tables

Session5: SQL Queries, Joins, Stored Procedures

Session6: Using Sql Parameters in Stored Procedures

Session7: Designing the User Form with a Data Grid

Session8: Writing the code for the Stored Procedure

Session9: Stored Procedures and Parameters

Session10: Create a Stored Procedure to Update a Table

Session11: Coding for the Update

Walkthrough 1: Code your own Email Client Learn how to send and receive emails using VB and C# code

Step1: Design a User Form for an Email Client

Step2: The Smtp Client

Step3: New Mail Message

Step4: Email Attachments in .NET

Step5: POP3 Servers and Commands

Step6: Contacting the POP3 Server

Step7: POP3 Server Authentication

Step8: Do you have eMail?

Step9: Getting a List of Messages

Step10: Getting the Email

Step11; Parsing the Email

Step12: Deleting Emails from the Server

Walkthrough 2: Code your own Picture Viewer

Step1: Picture Viewer Project – Designing the Form

Step2: Images and the ImageList Control

Step3: Adding Images and ListView

Step4: The Bigger Picture

Step5: Coding for Image Zoom

Walkthrough 3: Excel Data and Charts Project Create charts in VB and C# using data pulled from Excel

Step1: Introduction to the Project

Step2: The Chart Project Form

Step3: Connecting to Excel

Step4: Working with Excel Ranges in C# and VB Net

Step5: The ComboBox and Selecting Items

Step6: Creating a Chart from the Excel Data

Step7: The X Axis

Step8: Lines and Markers

Step9: Backgrounds, Titles, Rounded Corners

Walkthrough 4: Write a Text to Speech Program Write an app that speaks! Read Text Files, PDFs, Word Docs, Web Pages

Step1: Intro to the Text to Speech Project

Step2: Designing the Form

Step3: Load Voices

Step4: Coding for the Speak Button using the SpeechSynthesizer Class

Step5: Pause, Resume, Stop

Step6: Which File Type was Opened?

Step7: Speech and Text Files

Step8: Open PDF and Get the Text

Step9: Open a Microsoft Word File with Code

Step10: Pronounce Highlighted Word

Step11: Get Text from URL

Walkthrough 5: A Stick Figure Cartoon App Full program walkthrough! (Includes lesson on Version Control)

Step1: Create your own Stick Figure Cartoon Program – Introduction