Real World Project From Scratch by Windows Forms – C# Net Core 6 by SQL Database – Crystal Reports
What you will learn
Live Full Graphical Project by C# .NET Core + SQL Database from scratch
Easily Learn Create Pro Windows Apps by .NET core – SQL database in C# – SAP Crystal Reports
Using C#.NET Core by SQL Server to Create Database Apps – SAP Crystal Reports in C#, Using AES to encrypt and decrypt password
SAP Crystal Reports to design reports in C#
SQL Server, It’s installation & Using in C#
Using AES to encrypt and decrypt password
Description
Hi There!
With my 23 years programming skills I’m with you to share my knowledge with you.
So
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’s 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, It’s 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 …
Don’t 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 let’s go !!!
English
language
Content
Introduction
Introduction
About me!
Download project files of this course
Designing Main Form
Start Secretariat Application in C# .NET 6
Adding main panels
Minimize and close buttons
Top menu buttons
Add calendar to sidebar
Add analog clock to sidebar
Customize appearance of analog clock
Add login user image to sidebar
Data entry menu by treeview
SQL – Quick Review of SQL Server
Who should watch this section!
Download & install SQL 2014 on Windows 10 and Windows 7
Start using SQL server and SSMS
Working with SQL database
Using SQL Server configuration manager
Using SQL Server Table
SQL Numeric Data types
SQL English Text Data types
SQL Unicode Text Data types
GUID datatype in SQL
How to Attach, Detach and offline the SQL database
Identity and Auto Increment Column in SQL Server
SQL Date Time Data types
Project => Create “Phone Book” database in SQL
Select Query In SQL
Using SQL in C# by ADO.NET
What is ‘incoming letters’ form?
Structure of ADO .NET to use database in C#
Create database for incoming letters
Connect SQL Db to C# by : TableAdapter, Dataset, …
Deeper look at: TableAdapter, Dataset and Datatable
How to Back up and restore C# project?
Design: “Incoming Letters List” Form
Add “incoming letters list” form and set common properties
Loading data in to DataGridView
Customizing DataGridView
Adding record navigator to form
Add top buttons to form
Adding Search panel to form
Searching SQL data by ID in C#
Searching SQL data by ‘Subject’ in C#
Searching SQL data by ‘Reg Date’ in C#
Design: “Incoming Letters” Form
Add “incoming letters” form and set common properties
Add top buttons to form: Add, Edit, Delete, Save Cancel
Add sys date & time to footer and set values by C#
Add user name & id to footer and set values by C#
Adding data entry items to form
Bind the data entry items to bindingsource
C# code for New, Edit and save buttons
C# code for Delete and Cancel buttons
Customize date format by App culture
Assign default values for date, time controls and…
Set mask to date and time maskedtexboxes
Validate the date before saving in SQL db
Connect data entry form to it’s parent form
Connect ‘Incoming letters list’ to main form
Save the null values in the date columns
Design: “Outgoing Letters” Form
Quick tour of ‘Outgoing letters’ form
Creating SQL database for ‘Outgoing letters’
Connecting ‘Outgoing letters’ SQL table to C#
Design ‘Outgoing letters list’ form
Design ‘Outgoing letters’ data entry form
Connect ‘Outgoing letters list’ to main form
Save the null values in the date columns of “Outgoing Letters”
Design: Users Management
Quick tour of “Users Management”
Creating SQL database for ‘Users’
Connecting ‘Users’ SQL table to C#
Design ‘App Users List’ form
Design ‘App Users’ data entry form
Add User photo to data entry form
Design “Login Form”
Add protection to “Users Data Entry” form
Connecting “App User” form to main form
User Permissions
Quick tour of “User Permissions”
Create database for “User Permissions”
Add permission columns from SQL to C# Datatable
Adding permission sections to “Users Form”
Bind permission Checkboxes to Bindingsource
Load user permission data in the “Main Form”
C# code to load user permission by column name
Load permission for the “Main Form”
Load permission for all other forms
Reload permissions by closing the “User List” form
Design: Backup and Restore Forms
Quick tour of “Backup & Restore”
Design the “Backup” and “Restore” forms
C# code for “Browse Button on the “Backup Form”
Backup data in SSMS ( SQL Server Management Studio)
Backup SQL database in C#
Show message & progress panel while backing up
Restore data in SSMS ( SQL Server Management Studio)
Restore SQL Database by C#
Add protection before restore SQL Db
Background Changer of Main Form
Quick tour of background changer
Add background selector panel to main form
C# code to create Thumb images from background images
Add method to load background thumb images
Change main form background by selecting the thumb image
Structure of cropping background image for main form
Resize background image to the screen size by C#
C# method to crop the background image
Crop main form image by C# for Sidebar, Top, Bottom & Main panel
Load all parts of main form background image by C#
Select the thumb control for last selected background image
Add semi transparent overlay color to main form controls
C# code to select custom background image
Quick Review: Crystal Reports in C#
Who should watch this section?
Download projects and files of this course
Download and install Crystal Reports in C#
Prepare the C# project for Crystal Reports in C#
Start using SAP Crystal Reports in C#
Design Pro Report by: Text object, Line, Box and picture
Page setup of report: Paper size, margin ,…
Customizing: Details items, Numeric, Date, Time & Currency columns
Special fields: Print date & time, record number, page number , …
Adding total numbers – sort the records in crystal reports
Show full screen report from file & customize crystal report viewer
Reports by SAP Crystal Reports
Quick tour for using the crystal reports in .NET core apps
Add new .Net framework project to use Crystal Reports
Add Dataset, TableAdapter , … in Crystal Reports project
Add and load a simple report of Crystal Reports
C# code to run reports “Exe” file by sending parameter to it
Using dataset to send data between .Net core app and reports app
Design and load a report for incoming letters list
Running directly the Crystal Reports application
Design report to load all details of each record for incoming letters
Design 2 reports for Outgoing letters
Add reports to menus in the main form
Finalize the Project
Add background image to login form
Add shortkeys to main form and other forms
Assign icon to .NET core app and crystal reports app
Change Executable file name of project
Assign versioning information to projects
Create about us form and load version info by C#
Run Windows calculator by C# code
Clean up the TaskList before publishing app
Custom “Connection String” Form
Add “SQL Connection Setting” form to project
C# code to generate and save custom SQL connection string
C# code to load the custom connection string
Testify the custom connection string inside project
What is AES Encryption method?
Encrypt & Decrypt connection string by AES in C#
Assign custom connection string to all TableAdapters in project