C# Basic And Advanced: Creating A Point Of Sale System

Learn from a beginner to be a C# & Database programmer.

What you'll learn
Learn the fundamentals of C# and .NET Framework
Learn development tools such Visual Studio and Microsoft SQL Server
Learn the difference between variable types
Learn Control the flow of programs using conditional statements such If and loop
Learn Events
Learn how to design graphic user interfaces
Learn how to design database and create a table for C#
Learn SQL commands such SELECT, UPDATE, and DELETE
Learn C# database programming
Develop a Phone book Project as a workshop
Develop a Point of Sale System as a workshop
Print a receipt and report by using RDLC
Learn how to develope POS
Building POS
Building Applications
Coding C# to read bardcode by using scanner
Learn Microsoft SQL Server
Get the source code of workshop
Requirements
No Need Any prerequisites
Description
Welcome to the C# Basic and Advanced: Creating a Point of Sale SystemThe course covers all the fundamental concepts of C# and Microsoft SQL SERVER for Database. We include the most interesting and essential topics in this course. This is the most comprehensive C# and Database that will make you successful in C# Database Programming.The experienced instructor will teach you from the beginning level until you can make business software such as a Point-of-Sale System by yourself. The course will give you an idea of programming, so you can develop software by yourself after finish this course.The course has been created for months to make sure that students get the best C# course. The instructor tries to make everything in the course simple and step-by-step. No matter you are a newbie, at the end of the course, you will be a professional programmer.Don't waste your time looking for other courses. There are many online courses that give you only a simple technique. This is the best C# programming class.We will not let our students behind. The instructor always answers students when they have a problem. We will give the best to support our students. In addition, even though the course is ended, but it is not really ended. We will keep updating the course and uploading an extra video for our students.

Overview

Section 1: Introduction

Lecture 1 Welcome

Section 2: Introduction to Development Tools

Lecture 2 Install Visual Studio IDE

Lecture 3 Install Microsoft SQL Server

Lecture 4 Getting to Know a Development Tool

Lecture 5 Save and Close a Project

Section 3: Basic C#

Lecture 6 Variables in Brief

Lecture 7 Convert a Variable

Lecture 8 Events in C# Programming

Lecture 9 Conditional Statements - If and Else

Lecture 10 Loops

Lecture 11 Functions - Part I

Lecture 12 Functions - Part II

Section 4: Introduction to Database

Lecture 13 The fundamental of database

Lecture 14 Create a database, table and learn SQL command

Section 5: Workshop 1: Contact book Software

Lecture 15 Design a Program and Database, Code C# to Connect, Insert and Select information

Lecture 16 Update, Delete, Search Information from Database Via C# programming

Section 6: Workshop 2: Develop a Point of Sale System for the Real World

Lecture 17 Code Login or Authentication Form

Lecture 18 Design a Main Form

Lecture 19 Design Form Inventory

Lecture 20 Show Information from Database in Datagridview

Lecture 21 Show Information from a Selected Column of Datagridview in Textboxes

Lecture 22 Add Product to a Table in Database

Lecture 23 Update Production's Information in Database

Lecture 24 Delete Product's Information

Lecture 25 Search Product Information

Lecture 26 Design a User Form

Lecture 27 Show Users from Database

Lecture 28 Add a User to Database

Lecture 29 Update User's Information

Lecture 30 Delete User's Information

Lecture 31 Design a Cashier Form

Lecture 32 Scan Barcode to Add Product to a Datagridview

Lecture 33 Fixing a Mistake From The Previous Lesson

Lecture 34 Remove a Scanned Product from Datagridview

Lecture 35 Calculate the Total Amount of the Scanned Products

Lecture 36 Calculate Change

Lecture 37 Enable and Disable the Checkout Button

Lecture 38 Save Sale Information

Lecture 39 Save Sale Detail Information

Lecture 40 Create a receipt form

Lecture 41 Install RDLC for creating a Report of a Receipt

Lecture 42 Create a Dataset and a Report for a Receipt

Lecture 43 Create and Design a Form for a Sale Report

Lecture 44 Get Data form Database and Show in a Sale Report Form

Lecture 45 Pass a DataTable from the Login Form to a Main Form and Cashier Form

Section 7: Source Code

Lecture 46 The Source Code of Workshop 2 (Develop a Point of Sale System for the Real Worl)

Lecture 47 How to open the source code of workshop 2

Newbies who want to learn C#, .Net Framework, and Database,Student who want refresh and learn more about C#, .Net Framework, and Database,Beginner to Advanced programmers