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

[InspireProgrammer]

If you like my efforts, gift me a coffee on

[gfim-godsfamilyint.ministr]

Great work sir. It made me follow and enjoyed programming in c# which I always wanted to do but was unable. This your tutorial series put my interest back into programming. The course videos were very very explicit and functional. Thank you so much.

[zameer_ul_haq]

so happy i found this channel can you do complete series like this on payment and attendance (using fingerprint if you can)

[InspireProgrammer]

Course Contents
@ Introduction to Users Management - Course Contents
@ Project Demo
@ Database Design For Users Management - Users - Roles and Previlages
@ Create New Project and Configure Connection String with SQL
@ Design Template Form - Apply Same Styles To All New Forms
@ Save New User Role in Database using Form Validation & Store Procedure
@ Load Roles Data From Databse and Display in Data Grid View
@ Search Roles - Search Record From SQL using C# and Like Operator with Store Procedure
@ Reload Data For Update - Transfer Data From Data Grid View and Display To Another Form
@ Update Role - Update Data From Winform to SQL using Store Procedure
@ Delete User Role - Delete Data From SQL using Winform and Store Procedure
@ Use Confirmation Before Delete or Update Operations -Use Dialog Result
@ Designing Users Registration Form with Form Validations
@ Load Roles - Load Data Into Combo Box from SQL using Store Procedure
@ Save User Information in SQL with Form Validations using Store Procedure
@ Password Encryption - Encrypt and Save Data into SQL using C# MD5
@ Display Users - Load Data From Sql To Data Grid View using INNER Join in
@ Search User by User Name and Role - Search using Like Operator and Inner Join
@ Reload User Information For Update - Transfer Values to next form controls
@ Update User Record - How to Update Data into SQL Table from win form C#
@ Delete User Record - How to Delete Record from SQL using C# and Store Procedure
@ Design & Code Login Form - Create Login Form using C# and SQL Store Procedure
@ How to Design Dashboard Form or Main Menu Form in Win Form C#
@ Design Change Password Form and Form Validations using C# Win Form
@ Get Logged In User Detail and Display in Main Menu
@ Change Password From Winform to SQL after verifying old password
@ Restrict Access - Displaying Different Menu To Admin and Other Users
@ Create Project Template & Use Users Management for your next projects

[mhhutama]

Waalaikumsalam brother, thanks alot for great course

[tahir]

Very Informative, great help. Thank you very much for making these tutorial videos!

[raziahmad]

Masha Allah Raouf Bhai...
Jazak Allah for this series...
This is awesomely described...

Please aur series upload Karen, aur thoda complecated project upload Karen...

Aapse bahut kuchh seekhne ko milta hai...
Thanks a lot for this channel...

[SunShine]

Mash ALLAH may Allah blessed you..you are very perfect man

[DChristop]

So nice to be in our lifes with soooo amazing videos!!! Thanks a lot!!!

[iamalihassanonline]

Police Yusuf video thank you
And best of luck 😘

[akram._.]

شكراً جزيلا
بارك الله فيك و جعله في ميزان حسناتك

[manishbfmv]

Very helpful and informative, appreciate your hard work on this a big thumbs up..

[mohammedghwale]

first of all great tutorial & thanks for your efforts but you forgot to show how to prevent the error when entering a new user with a username that already exists thank you again

[UM]

Apki vjha say hamein bht kuch sekhnay ko milta ha! Kindly share me you’re 1st youtube channel please..!

[shollymore]

Hi there thanks for this detailed tutorial really helpful. I was wondering if you already have a tutorial of have any plans to release a tutorial where a User Role can be checked against different (services/subscriptions) and return true or false depending on the role entitlement?

[vijayakumarg]

Thanks for tutorial, It is very useful. Can you share me a source code??

[amanullahkhan]

AoA Sir! It very helpful tutorial for first as programmer. Thank you very much. "Allah apko Ajar de".
Sir I have some answer:
1. How to deploy the app on single computer or local network.
2. Sir you have restrict user for some operation with role ID in switch statement like 1, 2, 3. but sir If admin delete user on Role ID 2 OR 3, then what will be happen. Then Admin will again contact to developer for fixing this issue. Please clear confusion if possible.

3. Please refer any tutorial for saving data using radio button, list control box.

[AddictedToGaming]

in the usersdatagridview double click event, the line "string userName = is giving me an index out of bounds exception even though it works in the video, can anyone help?

[mohammedghwale]

since the users can add new roles.. shouldn't the access privileges be also specified by the user?

[AddictedToGaming]

cool tutorial, can i look at the source code somewhere? :)