Live Accounting With C#.Net Core In Windows Forms And Sql

Real World Accounting Project From Scratch by Windows Forms - C# Net Core 8 by SQL Database -Print , Pdf and Excel

What you'll learn

Live Full Graphical Accounting Project by C# .NET Core + SQL Database from scratch

Quickly Learn from Scratch to Create Pro Accounting App by .NET core - SQL Database in C#

Using C#.NET Core to Create SQL Database Apps

Print the reports, Export to Excel and Pdf

Design of amazing graphical Main form

Design users management form

Design SQL database and use it in C# by ADO. Net

Design "SQL Connection Setting" form

Requirements

General knowledge of C#

Visual Studio 2022 Free Community Edition and Some Patience!

Description

Hi There!Here I am with you to share my knowledge with you.SoIf 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 CoreIf 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 ScratchDesigning Main FormUsing SQL in C# by ADO. NETSQL Server, Its installation and workingCreate database App with SQL and C#Using Pdf engine to design amazing reports in C#Working with settings in ApplicationDesign: "Customers Data Entry" FormDesign: "Products Data Entry" FormDeeper look at: TableAdapter, Dataset and DatatableCustomizing DataGridViewCreate database for AccountingAdd digital clock to main formAdd login user image to main formand …Do not hesitate to start learning C# .NET Core 8Every thing will be discussed with sample project and you will have lot of fun within my course.Say Hi C# world and lets go !

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Download project files of this course

Section 2: Start working with Accounting

Lecture 3 Creating accounting project

Section 3: Designing main form

Lecture 4 Designing main form

Lecture 5 Designing bottom panel

Lecture 6 Changing background image

Lecture 7 Reload selected background

Lecture 8 Start using tree view

Lecture 9 Tree view c# code

Section 4: Using SQL in C#

Lecture 10 Ado.net structure

Lecture 11 Customer database in sql

Lecture 12 Adding sample data

Lecture 13 Adding Dataset to project

Lecture 14 Install Nuget packages

Lecture 15 Adding DataTable and TableAdapter

Lecture 16 Deep dive DataTable and TableAdapter

Lecture 17 Designing customer form

Lecture 18 Binding data to item on form

Lecture 19 Enable and disable buttons on form

Lecture 20 c# code for top button

Lecture 21 Customize DataGridView

Lecture 22 Adding C# code for registration data

Lecture 23 Searching SQL Data in C#

Lecture 24 Connecting customer to main form

Section 5: Designing products form

Lecture 25 Creating product table in sql

Lecture 26 Using database in application

Lecture 27 Designing the products form

Lecture 28 Writing the code for product form

Section 6: Designing setting form

Lecture 29 Designing setting form

Lecture 30 C# code for settings form

Section 7: Sales Invoice

Lecture 31 Create invoice table in sql

Lecture 32 Adding sql table to dataset

Lecture 33 Designing sales invoice form

Lecture 34 C# code for sales invoice form

Lecture 35 Designing Customers search form

Section 8: Products Form

Lecture 36 Adding products database in sql

Lecture 37 Designing products form

Lecture 38 C# code for product form

Lecture 39 Customizing product DataGridView

Lecture 40 Designing product search form

Lecture 41 Assigning default value for numeric columns

Lecture 42 Formatting numeric columns in DataGridView

Lecture 43 Connecting 'product search' to product form

Lecture 44 Auto calculate sum in ‘product’ form

Lecture 45 Adding some protections to code

Lecture 46 Calculate sum of data

Section 9: Receive Money Form

Lecture 47 Designing receive money form

Lecture 48 C# code for the receive money form

Lecture 49 Connect receive money to sales invoice

Lecture 50 Calculate sum of receive money

Lecture 51 Adding guard to negative numbers

Lecture 52 Fixing bug of Receive money

Section 10: Purchase Bill

Lecture 53 Design sql database for purchase bill

Lecture 54 Connecting database to application

Lecture 55 Design purchase bill form

Lecture 56 C# code for purchase bill

Lecture 57 Purchase product list design

Lecture 58 C# code for Purchase product

Section 11: Spend Money Form

Lecture 59 Design spend money form

Lecture 60 C# code for spend money form

Lecture 61 Bug of edit button in spend money

Section 12: Cost Form

Lecture 62 Create expense table

Lecture 63 Design cost form

Lecture 64 C# code for cost code

Section 13: Quick Review of PDF & Excel in C#

Lecture 65 Who should watch this section

Lecture 66 Download project files of this section

Lecture 67 Creating project for Excel

Lecture 68 Installing NuGet for excel

Lecture 69 Creating SQL db for Excel

Lecture 70 Connecting db to project

Lecture 71 Adding items and DGV

Lecture 72 Loading Excel file

Lecture 73 Reading Excel data

Lecture 74 Adding progress bar

Lecture 75 Save Excel data in SQL

Lecture 76 Fix the date bug

Lecture 77 Loading all data

Lecture 78 Exporting data to excel

Lecture 79 Installing Pdf package

Lecture 80 Create empty pdf file

Lecture 81 Add report title to pdf

Lecture 82 Add free space & line

Lecture 83 Add table header to pdf

Lecture 84 Add table data to pdf

Lecture 85 Show progress panel

Lecture 86 Format decimal columns

Section 14: Print, PDF and Excel in C#

Lecture 87 Installing pdf package

Lecture 88 Adding print button

Lecture 89 Export to pdf in cost form

Lecture 90 Adding print to cost form

Lecture 91 Installing excel package in Nuget

Lecture 92 Export to excel in cost form

Lecture 93 Print data in receive money form

Lecture 94 Adding print to spend money form

Lecture 95 Adding print to products form

Lecture 96 Adding print to customers forms

Section 15: Print for Purchase and Sale Invoice

Lecture 97 List of invoices

Lecture 98 Adding print to invoice list

Lecture 99 List of purchase bill

Lecture 100 Invoice print part 1

Lecture 101 Invoice print part 2

Lecture 102 Adding print to Purchase Bill form

Section 16: Users and Login Forms

Lecture 103 Creating user database

Lecture 104 Adding user form

Lecture 105 Designing user form

Lecture 106 Writing C# code for user form

Lecture 107 Browse button in user form

Lecture 108 Designing login form

Lecture 109 Writing C# code for login form

Lecture 110 Connecting login user to main form

Section 17: Finalizing Project

Lecture 111 Adding about us form

Lecture 112 Adding ShortKeys to main form

Lecture 113 Designing SQL connection form

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