C# and SQL Step By Step Tutorial - Users Management System - Users | Roles | Login | User Privileges

In this video tutorial you will learn about C# and SQL Step By Step Tutorial - Users Management System - Users | Roles | Login | User Privileges

This is the complete tutorial for those who are interested to secure their desktop applications using C# and SQL. Securing Includes your application
should allow to create new users, view users, update users, delete users, create new roles, view roles, update roles, delete roles, assign roles
to users, block or restrict users, login, logout and change password.

Course Contents
00:00:00 Introduction to Users Management - Course Contents
00:12:31 Project Demo
00:17:36 Database Design For Users Management - Users - Roles and Previlages
00:25:38 Create New Project and Configure Connection String with SQL
00:38:15 Design Template Form - Apply Same Styles To All New Forms
00:45:53 Save New User Role in Database using Form Validation & Store Procedure
01:04:38 Load Roles Data From Databse and Display in Data Grid View
01:14:32 Search Roles - Search Record From SQL using C# and Like Operator with Store Procedure
01:27:28 Reload Data For Update - Transfer Data From Data Grid View and Display To Another Form
01:43:55 Update Role - Update Data From Winform to SQL using Store Procedure
01:51:21 Delete User Role - Delete Data From SQL using Winform and Store Procedure
01:56:22 Use Confirmation Before Delete or Update Operations -Use Dialog Result
02:00:40 Designing Users Registration Form with Form Validations
02:02:45 Load Roles - Load Data Into Combo Box from SQL using Store Procedure
02:09:59 Save User Information in SQL with Form Validations using Store Procedure
02:25:05 Password Encryption - Encrypt and Save Data into SQL using C# MD5
02:34:45 Display Users - Load Data From Sql To Data Grid View using INNER Join in
02:43:37 Search User by User Name and Role - Search using Like Operator and Inner Join
02:49:57 Reload User Information For Update - Transfer Values to next form controls
03:03:35 Update User Record - How to Update Data into SQL Table from win form C#
03:12:49 Delete User Record - How to Delete Record from SQL using C# and Store Procedure
03:18:32 Design & Code Login Form - Create Login Form using C# and SQL Store Procedure
03:35:41 How to Design Dashboard Form or Main Menu Form in Win Form C#
03:43:54 Design Change Password Form and Form Validations using C# Win Form
03:54:33 Get Logged In User Detail and Display in Main Menu
04:01:50 Change Password From Winform to SQL after verifying old password
04:15:25 Restrict Access - Displaying Different Menu To Admin and Other Users
04:25:32 Create Project Template & Use Users Management for your next projects

All of above mentioned concepts are explained and practically implemented in this complete course.

The main benefit of this tutorial series is that you can export this project as an template and you can then reuse this project for your next projects rather than writing every thing from scrach or copy pasting.

#CSharp #SQL #UserManagement #CompleteCourse

Видео C# and SQL Step By Step Tutorial - Users Management System - Users | Roles | Login | User Privileges канала Inspire Programmer