Fast SQL in VB .NET -Live Accounting Project By Visual Basic

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Download project files of this course

Chapter 2: Start working with Accounting

Lecture 1: Main parts of accounting software

Lecture 2: Creating accounting project

Chapter 3: Designing main form

Lecture 1: Designing main form

Lecture 2: Designing bottom panel

Lecture 3: Changing background image

Lecture 4: Reload selected background

Lecture 5: Start using tree view

Lecture 6: Tree view VB code

Chapter 4: Using SQL in VB

Lecture 1: Ado.net structure

Lecture 2: Customer database in sql

Lecture 3: Adding sample data

Lecture 4: Adding Dataset to project

Lecture 5: Install Nuget packages

Lecture 6: Adding DataTable and TableAdapter

Lecture 7: Deep dive DataTable and TableAdapter

Lecture 8: Designing customer form

Lecture 9: Binding data to item on form

Lecture 10: Enable and disable buttons on form

Lecture 11: vb code for top button

Lecture 12: Customize DataGridView

Lecture 13: Adding VB code for registration data

Lecture 14: Searching SQL Data in VB

Lecture 15: Connecting customer to main form

Chapter 5: Designing products form

Lecture 1: Creating product table in sql

Lecture 2: Using database in application

Lecture 3: Designing the products form

Lecture 4: Writing the code for product form

Chapter 6: Designing setting form

Lecture 1: Designing setting form

Lecture 2: VB code for settings form

Chapter 7: Sales Invoice

Lecture 1: Create invoice table in sql

Lecture 2: Adding sql table to dataset

Lecture 3: Designing sales invoice form

Lecture 4: VB code for sales invoice form

Lecture 5: Designing Customers search form

Chapter 8: Products Form

Lecture 1: Adding products database in sql

Lecture 2: Designing products form

Lecture 3: VB code for product form

Lecture 4: Customizing product DataGridView

Lecture 5: Designing product search form

Lecture 6: Assigning default value for numeric columns

Lecture 7: Formatting numeric columns in DataGridView

Lecture 8: Connecting 'product search' to product form

Lecture 9: Auto calculate sum in ‘product’ form

Lecture 10: Adding some protections to code

Lecture 11: Calculate sum of data

Chapter 9: Receive Money Form

Lecture 1: Designing receive money form

Lecture 2: VB code for the receive money form

Lecture 3: Connect receive money to sales invoice

Lecture 4: Calculate sum of receive money

Lecture 5: Adding guard to negative numbers

Chapter 10: Purchase Bill

Lecture 1: Design sql database for purchase bill

Lecture 2: Connecting database to application

Lecture 3: Design purchase bill form

Lecture 4: VB code for purchase bill

Lecture 5: Purchase product list design

Lecture 6: Vb code for Purchase product

Chapter 11: Spend Money Form

Lecture 1: Design spend money form

Lecture 2: VB code for spend money form

Chapter 12: Cost Form

Lecture 1: Create expense table

Lecture 2: Design cost form

Lecture 3: VB code for cost code

Chapter 13: Quick Review of PDF & Excel in VB

Lecture 1: Who should watch this section

Lecture 2: Download project files of this section

Lecture 3: Creating project for Excel

Lecture 4: Installing NuGet for excel

Lecture 5: Creating SQL db for Excel

Lecture 6: Connecting db to project

Lecture 7: Adding items and DGV

Lecture 8: Loading Excel file

Lecture 9: Reading Excel data

Lecture 10: Adding progress bar

Lecture 11: Save Excel data in SQL

Lecture 12: Fix the date bug

Lecture 13: Loading all data

Lecture 14: Exporting data to excel

Lecture 15: Installing Pdf package

Lecture 16: Create empty pdf file

Lecture 17: Add report title to pdf

Lecture 18: Add free space & line

Lecture 19: Add table header to pdf

Lecture 20: Add table data to pdf

Lecture 21: Show progress panel

Lecture 22: Format decimal columns

Chapter 14: Print, PDF and Excel in VB

Lecture 1: Installing pdf package