Section 1 : Introduction

Lecture 1 Introduction 1:27
Lecture 2 Payroll System Requirement 5:33
Lecture 3 Installation Guide 2:11

Section 2 : Database Design

Lecture 4 Create Database Tables and Relationship 10:48

Section 3 : Employee Form Module

Lecture 5 Employee Form Design 17:48
Lecture 6 Implicit Validation 8:57
Lecture 7 Explicit Validation 15:51
Lecture 8 Regular Expression - Part 1 12:11
Lecture 9 Regular Expression - Part 2 13:27
Lecture 10 Clear Controls 4:20
Lecture 11 PreviewForm - Parameter vs Argument - Part 1 12:58
Lecture 12 PreviewForm - Parameter vs Argument - Part 2 11:44
Lecture 13 Introduction to ADO 3:53
Lecture 14 Add Functionality 19:14
Lecture 15 Update Functionality Part 1 6:11
Lecture 16 Update Functionality Part 2 7:31
Lecture 17 Delete Employee Records 5:54
Lecture 18 Code Review 4:7

Section 4 : Payroll Calculator Module

Lecture 19 Payroll Calculator Form Design Part 1 10:33
Lecture 20 Payroll Calculator Form Design Part 2 13:13
Lecture 21 Retrieve Employee - DataReader 14:38
Lecture 22 Array Vs List Collection 16:32
Lecture 23 For Loop vs Foreach Loop vs ForEach Method 5:34
Lecture 24 Payroll Computation - Part 1 15:6
Lecture 25 Payroll Computation - Part 2 10:34
Lecture 26 Saving PayRecords - using Parameterised Command 14:57
Lecture 27 Pass-By-Value vs Pass-By-Reference
Lecture 28 Out vs Ref Keywords
Lecture 29 Time to Decimal Conversion 13:24
Lecture 30 Linked Label and Digital Timer 5:24
Lecture 31 String vs StringBuider Class

Section 5 : Search Functionality

Lecture 32 Search Functionality 11:15

Section 6 : Printing Functionality

Lecture 33 Printing Functionality - Payslip 19:15

Section 7 : AboutBox MDI and MenuStrip

Lecture 34 AboutBox - Product Information 6:4
Lecture 35 Multiple Document InterfaceMDI and MenuStrip 19:48

Section 8 : Reporting Facilities

Lecture 36 Reporting facilities - Part 1
Lecture 37 Reporting Facilities - Part 2 14:29

Section 9 : Log In and Registration Module - Users Class

Lecture 38 LogIn and RegisterUser Form Design 16:22
Lecture 39 Registered Users Table 3:10
Lecture 40 Complex Password Validation 19:47
Lecture 41 Class Object and Member Variables 16:47
Lecture 42 Constructors 6:30
Lecture 43 Properties Methods - Class Member 9:5

Section 10 : Using Stored Procedure

Lecture 44 Stored Procedure - spInsertCommand 18:21
Lecture 45 Stored Procedure - spUpdateCommand 11:28
Lecture 46 Stored Procedure - spDeleteCommand 5:39
Lecture 47 Stored Procedure - DataReader 9:24
Lecture 48 Stored Procedure - spAuthorisedUsers 13:14

Section 11 : Deployment

Lecture 49 FormClosing - Exiting Application 3:47
Lecture 50 Deployment - using ClickOnce