Fast C# .NET Core Live Project in Windows Forms and SQL

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to this course

Lecture 2: Download project files of this course

Chapter 2: Designing Main Form

Lecture 1: Start Secretariat Application in C# .NET 6

Lecture 2: Adding main panels

Lecture 3: Minimize and close buttons

Lecture 4: Top menu buttons

Lecture 5: Add calendar to sidebar

Lecture 6: Add analog clock to sidebar

Lecture 7: Customize appearance of analog clock

Lecture 8: Add login user image to sidebar

Lecture 9: Data entry menu by treeview

Chapter 3: SQL – Quick Review of SQL Server

Lecture 1: Who should watch this section!

Lecture 2: Download and install SQL 2014 on Windows 10 and Windows 7

Lecture 3: Start using SQL server and SSMS

Lecture 4: Working with SQL database

Lecture 5: Using SQL Server configuration manager

Lecture 6: Using SQL Server Table

Lecture 7: SQL Numeric Data types

Lecture 8: SQL English Text Data types

Lecture 9: SQL Unicode Text Data types

Lecture 10: GUID datatype in SQL

Lecture 11: How to Attach, Detach and offline the SQL database

Lecture 12: Identity and Auto Increment Column in SQL Server

Lecture 13: SQL Date Time Data types

Lecture 14: Project => Create "Phone Book" database in SQL

Lecture 15: Select Query In SQL

Lecture 16: Where clause

Chapter 4: Using SQL in C# by ADO.NET

Lecture 1: What is 'incoming letters' form?

Lecture 2: Structure of ADO .NET to use database in C#

Lecture 3: Create database for incoming letters

Lecture 4: Connect SQL Db to C# by : TableAdapter, Dataset, …

Lecture 5: Deeper look at: TableAdapter, Dataset and Datatable

Lecture 6: How to Back up and restore C# project?

Chapter 5: Design: "Incoming Letters List" Form

Lecture 1: Add "incoming letters list" form and set common properties

Lecture 2: Loading data in to DataGridView

Lecture 3: Customizing DataGridView

Lecture 4: Adding record navigator to form

Lecture 5: Add top buttons to form

Lecture 6: Adding Search panel to form

Lecture 7: Searching SQL data by ID in C#

Lecture 8: Searching SQL data by 'Subject' in C#

Lecture 9: Searching SQL data by 'Reg Date' in C#

Chapter 6: Design: "Incoming Letters" Form

Lecture 1: Add "incoming letters" form and set common properties

Lecture 2: Add top buttons to form: Add, Edit, Delete, Save Cancel

Lecture 3: Add sys date & time to footer and set values by C#

Lecture 4: Add user name & id to footer and set values by C#

Lecture 5: Adding data entry items to form

Lecture 6: Bind the data entry items to bindingsource

Lecture 7: C# code for New, Edit and save buttons

Lecture 8: C# code for Delete and Cancel buttons

Lecture 9: Customize date format by App culture

Lecture 10: Assign default values for date, time controls and…

Lecture 11: Set mask to date and time maskedtexboxes

Lecture 12: Validate the date before saving in SQL db

Lecture 13: Connect data entry form to it's parent form

Lecture 14: Connect 'Incoming letters list' to main form

Lecture 15: Save the null values in the date columns

Chapter 7: Design: "Outgoing Letters" Form

Lecture 1: Quick tour of 'Outgoing letters' form

Lecture 2: Creating SQL database for 'Outgoing letters'

Lecture 3: Connecting 'Outgoing letters' SQL table to C#

Lecture 4: Design 'Outgoing letters list' form

Lecture 5: Design 'Outgoing letters' data entry form

Lecture 6: Connect 'Outgoing letters list' to main form

Lecture 7: Save the null values in the date columns of "Outgoing Letters"

Chapter 8: Design: Users Management

Lecture 1: Quick tour of "Users Management"

Lecture 2: Creating SQL database for 'Users'

Lecture 3: Connecting 'Users' SQL table to C#

Lecture 4: Design 'App Users List' form

Lecture 5: Design 'App Users' data entry form

Lecture 6: Add User photo to data entry form

Lecture 7: Design "Login Form"

Lecture 8: Add protection to "Users Data Entry" form

Lecture 9: Connecting "App User" form to main form

Chapter 9: User Permissions

Lecture 1: Quick tour of "User Permissions"

Lecture 2: Create database for "User Permissions"

Lecture 3: Add permission columns from SQL to C# Datatable

Lecture 4: Adding permission sections to "Users Form"

Lecture 5: Bind permission Checkboxes to Bindingsource

Lecture 6: Load user permission data in the "Main Form"

Lecture 7: C# code to load user permission by column name

Lecture 8: Load permission for the "Main Form"

Lecture 9: Load permission for all other forms

Lecture 10: Reload permissions by closing the "User List" form

Chapter 10: Design: Backup and Restore Forms

Lecture 1: Quick tour of "Backup & Restore"

Lecture 2: Design the "Backup" and "Restore" forms

Lecture 3: C# code for "Browse Button on the "Backup Form"

Lecture 4: Backup data in SSMS ( SQL Server Management Studio)

Lecture 5: Backup SQL database in C#

Lecture 6: Show message and progress panel while backing up

Lecture 7: Restore data in SSMS ( SQL Server Management Studio)