Name: Fast C# .NET Core Live Project in Windows Forms and SQL
Rating: 4.8 (43 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byMega Learning

Last updated 3/2025

English

What you'll learn

Live Full Graphical Project by C# .NET Core + SQL Database from scratch
Easily Learn from Scratch to Create Pro Windows Apps by .NET core - SQL Database in C#
Using C#.NET Core to Create SQL Database Apps
SAP Crystal Reports to design reports in C#
SQL Server, It's installation & Using in C#
Using AES to encrypt and decrypt password
Design of amazing graphical Main form
Backup and Restore form for SQL Database
Design About us form by using the Versioning info of App
Design users management form
Graphical Login form
Using images: Crop, resize, load & save images
Adding permission for each user
Design SQL database and use it in C# by ADO. Net
Design "SQL Connection Setting" form

Course content

15 sections • 163 lectures • 37h 48m total length

Introduction to this course5:36
Download project files of this course0:55
Very Important: Watch first!3:11

Who should watch this section!0:04
Download and install SQL 2014 on Windows 10 and Windows 729:58
Download SQL Server 2014 Express from the official page and install the engine with Management Studio on Windows 7 or 10, noting requirements, limitations, and .NET Framework prerequisites.
Start using SQL server and SSMS18:26
Discover how SQL Server handles multiple users with a core SQL engine, the SQL database and MDF files, and learn to set up and connect using SSMS and SQL queries.
Working with SQL database21:57
Using SQL Server configuration manager6:23
Using SQL Server Table35:47
SQL Numeric Data types42:42
SQL English Text Data types22:47
SQL Unicode Text Data types21:07
GUID datatype in SQL11:17
How to Attach, Detach and offline the SQL database16:08
Identity and Auto Increment Column in SQL Server43:48
SQL Date Time Data types16:22
Project => Create "Phone Book" database in SQL26:34
Select Query In SQL39:20
Where clause21:15
Use the where clause in SQL Server select queries to filter text and numeric data. Handle unicode with the N prefix and use operators like equal, not equal, and between.

Add "incoming letters" form and set common properties9:11
Add top buttons to form: Add, Edit, Delete, Save Cancel15:08
Add sys date & time to footer and set values by C#13:27
Add user name & id to footer and set values by C#8:19
Adding data entry items to form11:37
Bind the data entry items to bindingsource12:38
C# code for New, Edit and save buttons13:29
Write robust C# code for add, edit, and save operations by binding controls to a data table, using binding source and table adapter to update the SQL Server database.
C# code for Delete and Cancel buttons9:34
Customize date format by App culture14:00
Assign default values for date, time controls and...18:57
Set mask to date and time maskedtexboxes7:57
Validate the date before saving in SQL db15:41
Connect data entry form to it's parent form25:24
Connect 'Incoming letters list' to main form8:57
Save the null values in the date columns7:35

Quick tour of 'Outgoing letters' form3:19
Creating SQL database for 'Outgoing letters'24:47
Connecting 'Outgoing letters' SQL table to C#8:24
Design 'Outgoing letters list' form29:49
Design 'Outgoing letters' data entry form28:36
Connect 'Outgoing letters list' to main form5:14
Connect the outgoing letters list to the main form by detecting the outgoing node in the tree view and opening the outgoing letters form centered on the screen.
Save the null values in the date columns of "Outgoing Letters"5:02

Quick tour of "User Permissions"3:50
Create database for "User Permissions"17:45
Add permission columns from SQL to C# Datatable3:16
Adding permission sections to "Users Form"23:39
Bind permission Checkboxes to Bindingsource12:22
Load user permission data in the "Main Form"17:34
C# code to load user permission by column name9:37
Load permission for the "Main Form"19:23
Load permission for all other forms21:48
Reload permissions by closing the "User List" form11:18

Requirements

General knowledge of C#
Visual Studio 2022 Free Community Edition and Some Patience!

Description

Hi There!

With my 23 years programming skills I am with you to share my knowledge with you.

If you try you will be a c sharper!

If you wanna make a lot of money!

If you wanna find best jobs in programming!

If you Want to learn the C# .NET Core

If you are beginners or student looking for a tutorial that teach c# with real project in simplest way!

If you want really to be a programmer so it is best place that you can start to learn C#.

This course includes :

Start using C# with Visual Studio 2022 From Scratch
Designing Main Form
Using SQL in C# by ADO. NET
SQL Server, Its installation and working
Create database App with SQL and C#
SAP Crystal Reports to design amazing reports in C#
Working with settings in Application
Design: "Incoming Letters List" Form
Design: "Incoming Letters Data Entry" Form
Design: "Outgoing Letters" Form
Design: "Outgoing Letters Data Entry" Form
Deeper look at: TableAdapter, Dataset and Datatable
Customizing DataGridView
Create database for incoming letters
Add analog clock to sidebar
Add login user image to sidebar
and …

Do not hesitate to start learning C# .NET Core 6

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi C# world and lets go !

Who this course is for:

Anyone who wants to learn windows form and c# from scratch to build the pro Windows app

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 10min

Designing Main Form9 lectures • 2hr 3min

SQL - Quick Review of SQL Server16 lectures • 6hr 14min

Using SQL in C# by ADO.NET6 lectures • 1hr 17min

Design: "Incoming Letters List" Form9 lectures • 1hr 57min

Design: "Incoming Letters" Form15 lectures • 3hr 12min

Design: "Outgoing Letters" Form7 lectures • 1hr 45min

Design: Users Management9 lectures • 2hr 35min

User Permissions10 lectures • 2hr 21min

Design: Backup and Restore Forms9 lectures • 2hr 4min

Requirements

Description

Who this course is for: