Visual C# and ADO.NET Programming

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Payroll System Requirement

Lecture 3: Installation Guide

Chapter 2: Database Design

Lecture 1: Create Database, Tables and Relationship

Chapter 3: Employee Form Module

Lecture 1: Employee Form Design

Lecture 2: Implicit Validation

Lecture 3: Explicit Validation

Lecture 4: Regular Expression – Part 1

Lecture 5: Regular Expression – Part 2

Lecture 6: Clear Controls

Lecture 7: PreviewForm – Parameter vs Argument – Part 1

Lecture 8: PreviewForm – Parameter vs Argument – Part 2

Lecture 9: Introduction to ADO.Net

Lecture 10: Add Functionality

Lecture 11: Update Functionality Part 1

Lecture 12: Update Functionality Part 2

Lecture 13: Delete Employee Records

Lecture 14: Code Review

Chapter 4: Payroll Calculator Module

Lecture 1: Payroll Calculator Form Design Part 1

Lecture 2: Payroll Calculator Form Design Part 2

Lecture 3: Retrieve Employee – DataReader

Lecture 4: Array Vs List Collection

Lecture 5: For Loop vs Foreach Loop vs ForEach Method

Lecture 6: Payroll Computation – Part 1

Lecture 7: Payroll Computation – Part 2

Lecture 8: Saving PayRecords – using Parameterised Command

Lecture 9: Pass-By-Value vs Pass-By-Reference

Lecture 10: Out vs Ref Keywords

Lecture 11: Time to Decimal Conversion

Lecture 12: Linked Label and Digital Timer

Lecture 13: String vs StringBuider Class

Chapter 5: Search Functionality

Lecture 1: Search Functionality

Chapter 6: Printing Functionality

Lecture 1: Printing Functionality – Payslip

Chapter 7: AboutBox, MDI and MenuStrip

Lecture 1: AboutBox – Product Information

Lecture 2: Multiple Document Interface(MDI) and MenuStrip

Chapter 8: Reporting Facilities

Lecture 1: Reporting facilities – Part 1

Lecture 2: Reporting Facilities – Part 2

Chapter 9: Log In and Registration Module – User's Class

Lecture 1: LogIn and RegisterUser Form Design

Lecture 2: Registered User's Table

Lecture 3: Complex Password Validation

Lecture 4: Class, Object and Member Variables

Lecture 5: Constructors

Lecture 6: Properties & Methods – Class Member

Chapter 10: Using Stored Procedure

Lecture 1: Stored Procedure – spInsertCommand

Lecture 2: Stored Procedure – spUpdateCommand

Lecture 3: Stored Procedure – spDeleteCommand

Lecture 4: Stored Procedure – DataReader

Lecture 5: Stored Procedure – spAuthorisedUsers

Chapter 11: Deployment

Lecture 1: FormClosing – Exiting Application

Lecture 2: Deployment – using ClickOnce

Lecture 3: Source Code – GitHub Link