Fast C# By Windows Forms - Create Windows Apps, Sql In C#

Fast and deeply learn the C# by Creating Windows Apps- Beginners to advance -SQL in C#, Excel,PDF,Weather Forcasting…

What you'll learn

Learn C# with Projects , Beginners to Advance

Build 7 pro apps: Calculator , Digital clock, Student info, Excel, PDF, weather forecasting,…

Easily learn the basics of C# to advance topics by Windows form

Create pro application by SQL in C#

Export data to Excel file

Learn: Dialogs, Variables,Controls, Debug, Events

Working with resources and settings

Date and time - Calendar

Design report by PDF

Show weather and forcasting

Requirements

Windows 10 or 11 operating system

Description

Hi There!Do you want to learn the programing deeply and easily?Have you ever thought to learn C# via projects?Are you students or C# lover and you want to learn C# by windows forms?Here i am to show you how to learn easily an quickly the C# by many projects.In this course you're going to learn :3 Courses in One + 17 Hours + 7 live ProjectsCreate Windows Apps by C#Basics of C# like: variablesfor loop structureIf statementControls and eventsResources in C#Debugging the codesCreate calculator applicationDesign Student info  applicationBuild Weather forecasting application for windowsCreating multi-form projectsControls like : Button, TextBox, ComboBox, Datetime pickerCreate digital clockWorking with date and timeCreate a calendarAdvance using of ComboboxWorking with imagesDialogs in C#:Creating method in C#Design the windows app in C# and SQL ServerExport data to Excel fileCreate weather forecasting appCreate report by PDF fileand…Don't hesitate to start learning C# by up to 7 different  projects with many tips and tricks!In this course you are going to learn the C# deeply and easily with the best method.Let's get started !!!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Download projects of this course

Lecture 3 Visual Studio 2022 requirements

Lecture 4 Download and install visual studio 2022

Section 2: Starting C# Project

Lecture 5 First project in C#

Lecture 6 Form properties

Lecture 7 Using Button, Label and TextBox

Lecture 8 Project 1: Design "Student Reg" form

Section 3: C# Coding

Lecture 9 First C# code

Lecture 10 Comments in C#

Lecture 11 Change color by C#

Lecture 12 Change text by C# code

Lecture 13 Enable/Disable controls by C#

Lecture 14 SHow/Hide controls by C#

Section 4: Date and Time

Lecture 15 Using date and time in c#

Lecture 16 Project 2 : Digital clock in C#

Section 5: Variables

Lecture 17 String variable

Lecture 18 Int32 and Int64

Lecture 19 Float,Double and Decimal

Lecture 20 Bool

Lecture 21 Scope of variable

Section 6: C# Statements

Lecture 22 Simple IF

Lecture 23 Multiple IF

Lecture 24 Switch Case

Lecture 25 Using ComboBox

Lecture 26 For Loop

Section 7: Dialogs

Lecture 27 Color dialog

Lecture 28 Folder browser dialog

Lecture 29 Font dialog

Lecture 30 Open file dialog

Lecture 31 Save file dialog

Section 8: Project 3: Calculator in C#

Lecture 32 Design of calculator

Lecture 33 Numeric buttons codes

Lecture 34 Method is C#

Lecture 35 Operator buttons code

Lecture 36 Decimal button code

Lecture 37 Equal button code

Lecture 38 Try structure

Lecture 39 Publish calculator

Section 9: Project 4 : Student management App in C#

Lecture 40 Structure of database app

Lecture 41 Design Database

Lecture 42 Create new C# Project

Lecture 43 Add TableAdapter and datatable

Lecture 44 Deep diving TableAdapter & datatable

Lecture 45 Add ‘Students’ data entry form

Lecture 46 Design the top buttons

Lecture 47 Adding items to form

Lecture 48 Loading data in datagridview

Lecture 49 Bind the items to bindingsource

Lecture 50 Customize datagridview

Lecture 51 Enable and disable buttons

Lecture 52 C# code for New,Edit & Delete buttons

Lecture 53 Save button C# code

Lecture 54 Cancel button C# code

Lecture 55 Fix some bugs

Lecture 56 Add photo column to sql db

Lecture 57 Photo browse button

Lecture 58 Search form design

Lecture 59 Search data by id and grade

Lecture 60 Search text columns in SQL

Lecture 61 Search last name in C#

Lecture 62 Search date columns in SQL

Lecture 63 Search date column in C#

Lecture 64 Load all data in C#

Lecture 65 Main form design

Lecture 66 Adding close button

Lecture 67 Show other forms

Lecture 68 Showing date and time

Lecture 69 Change background image

Lecture 70 Adding minimize button

Lecture 71 Load selected background

Lecture 72 Create “user” database in SQL

Lecture 73 Design the “user” form

Lecture 74 Coding the “user” form

Lecture 75 Protect the codes via errors

Lecture 76 Design the login form

Lecture 77 Coding the “login” form

Lecture 78 Saving login user in database

Lecture 79 Design the settings form

Lecture 80 Coding the “settings” form

Lecture 81 Design the “about us” form

Lecture 82 Adding shortcuts to main form

Lecture 83 Run calculator from menu

Section 10: Project 5 : Weather forecasting

Lecture 84 What is the weather api?

Lecture 85 Create new project for weather

Lecture 86 Install json package from Nuget

Lecture 87 C# codes to get weather by api

Lecture 88 Search weather by city name

Lecture 89 Design a method to load weather data

Lecture 90 Change the unit of measurement

Lecture 91 Get the icon for weather

Lecture 92 Protecting weather codes by try

Lecture 93 Get weather data by longitude & latitude

Lecture 94 Change the language of return values

Lecture 95 What is weather forecasting

Lecture 96 Design the forecasting form

Lecture 97 Forecasting codes part1

Lecture 98 Forecasting codes part2

Section 11: Project 6 : Excel in C#

Lecture 99 Creating project for Excel

Lecture 100 Installing NuGet for excel

Lecture 101 Creating SQL db for Excel

Lecture 102 Connecting db to project

Lecture 103 Adding items and DGV

Lecture 104 Loading Excel file

Lecture 105 Reading Excel data

Lecture 106 Adding progress bar

Lecture 107 Save Excel data in SQL

Lecture 108 Fix the date bug

Lecture 109 Loading all data

Lecture 110 Exporting data to Excel

Section 12: Project 7: Report in PDF by C#

Lecture 111 Installing Pdf package

Lecture 112 Create empty pdf file

Lecture 113 Add report title to pdf

Lecture 114 Add free space & line

Lecture 115 Add table header to pdf

Lecture 116 Add table data to pdf

Lecture 117 Show progress panel

Lecture 118 Format decimal column

Any one who wanna learn C# Deeply and quickly