Visual C# and ADO.NET Programming
4.6 (118 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,615 students enrolled

Visual C# and ADO.NET Programming

Case Study - Payroll System
Highest Rated
4.6 (118 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,615 students enrolled
Created by Everest Nwosu
Last updated 1/2020
English
Current price: $59.99 Original price: $99.99 Discount: 40% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • By the end of the course, you should be comfortable developing and deploying basic business applications from Problem domain to Business Solutions using C# and ADO (dot) NET.
Course content
Expand all 51 lectures 09:20:36
+ Introduction
3 lectures 09:42
Payroll System Requirement
05:40
Installation Guide
02:20
+ Database Design
1 lecture 11:18
Create Database, Tables and Relationship
11:18
+ Employee Form Module
14 lectures 02:25:49
Employee Form Design
17:55
Implicit Validation
09:04
Regular Expression - Part 1
12:19
Regular Expression - Part 2
13:35
Clear Controls
04:28
PreviewForm - Parameter vs Argument - Part 1
13:06
Add Functionality
19:21
Update Functionality Part 2
07:39
Delete Employee Records
06:01
+ Payroll Calculator Module
13 lectures 02:45:12
Payroll Calculator Form Design Part 1
10:41
Payroll Calculator Form Design Part 2
13:20
Retrieve Employee - DataReader
14:46
Array Vs List Collection
16:40
For Loop vs Foreach Loop vs ForEach Method
05:42
Payroll Computation - Part 1
15:14
Payroll Computation - Part 2
10:42
Saving PayRecords - using Parameterised Command
15:04
Pass-By-Value vs Pass-By-Reference
17:59
Out vs Ref Keywords
08:03
Time to Decimal Conversion
13:31
Linked Label and Digital Timer
05:31
+ Printing Functionality
1 lecture 19:22
Printing Functionality - Payslip
19:22
+ AboutBox, MDI and MenuStrip
2 lectures 26:06
AboutBox - Product Information
06:11
Multiple Document Interface(MDI) and MenuStrip
19:55
+ Reporting Facilities
2 lectures 27:43
Reporting facilities - Part 1
13:06
Reporting Facilities - Part 2
14:37
+ Log In and Registration Module - User's Class
6 lectures 01:12:26
LogIn and RegisterUser Form Design
16:30
Registered User's Table
03:17
Complex Password Validation
19:55
Class, Object and Member Variables
16:55
Constructors
06:37
Properties & Methods - Class Member
09:12
+ Using Stored Procedure
5 lectures 58:45
Stored Procedure - spInsertCommand
18:29
Stored Procedure - spUpdateCommand
11:36
Stored Procedure - spDeleteCommand
05:47
Stored Procedure - DataReader
09:32
Stored Procedure - spAuthorisedUsers
13:21
Requirements
  • Little or no programming experience is assume at a beginner level
Description

This is a 9-hours comprehensive project-based course that covers everything required to develop and deploy a fully-functional, data-driven application from Business Needs, Graphic User Interface Design, Complex User Input Validations, ADO.NET Secure Database Programming, Searching Mechanism, Printing Functionality, Payroll Computation, Reporting Facilities, Multiple Document Interface & MenuStrip, Registration & Log In functionality, System Implementation and Deployment.

This is a Beginner's-Level course, and the goal here is to learn some basic C# and ADO.NET programming concepts, using a project-based approach.

By the end of the course, you should be comfortable developing and deploying a basic business applications from Problem domain to Business Solutions.


Who this course is for:
  • Any one interested in developing lightweight data-driven application development using C# programming language.