C#, the most versatile programming language in the .NET framework, allows developers to build Windows, web, and mobile applications. It has strong community support, and more than five million developers prefer C#. This course will teach you how to build a Windows Forms application using C#. The course starts by highlighting the learning objectives and explaining the installation process of Visual Studio 2022. Next, you will learn the basic and advanced concepts of C# console programming needed for application development. You will also understand how to use WinForms, ADO.Net, and Language Integrated Query (LINQ) to create WinForms applications. Moving along, you will learn to build data-driven GUI applications using Windows Forms and manage databases with SQL server management studio. Next, you will understand the concept of user management and learn how to use utility classes to keep the code clean. Later, you will learn to develop multi-document interface (MDI) applications and learn the techniques to add a Visual Studio project to source control. By the end of this course, you will have moved around in Visual Studio and examined logic and syntax errors so much that it will be second nature for you when working in the .NET environment. This will put your newly learned skills to practical use and impress your boss and co-workers.
Overview
COURSE DIFFICULTY
COURSE DURATION
15h
Skills Learned
After completing this online training course, students will be able to:
Find out how to create desktop applications with C#
Connect Windows Forms applications to a database
Discover how to use C# operators for math and logic tasks
Handle database changes and manage create, read, update, and delete (CRUD) operations
Write Language Integrated Query (LINQ) to retrieve data from databases
Connect to and upload a project to GitHub
01. Development Environment Setup
- Installing Visual Studio 2022 Community Edition
- Create Your First C# Console Project
- Visual Studio 2022 Community Edition Tour
- Understanding the Difference Between .NET 6 and Previous Versions
- Development Using Visual Studio Code
02. C# Console Programming – Basic Control Structures
- Understanding Basic C# Syntax
- Input and Output Programs
- C# Data Types and Conversion
- Application Debugging Techniques
- Arithmetic and Assignment Operators
- Conditional Statements
- Repetition Statements
03. C# Console Programming – More Advanced Concepts
- Methods – Void
- Methods – Value Returning
- String Manipulation Functions
- DateTime Manipulation Functions
- Exception Handling
- Arrays
- Lists
04. C# Console Programming – Object-Oriented Concepts
- Introduction to Classes and Objects
- Method Overloading
- Static Classes and Static Class Members
- Inheritance with Classes and Interfaces
- Constructors
05. Add Visual Studio Solution to GitHub
- Create GitHub Account
- Add Solution to Source Control
06. WinForms Applications – The Basics
- Visual Studio 2022 – Windows Forms Setup
- Creating a Simple WinForms Application (Car Rental Application)
- Understanding WinForms Controls, Properties, and Events
- Form Validation and Exception Handling
- Installing SQL Server Express Edition
- Creating a Database in a SQL Server
- Creating a Database Model with ADO.NET
- Selecting Data from the Database Using Language Integrated Query (LINQ)
- Submitting to Database from Form
07. Multi-Document Interface (MDI) and More Database Operations
- Creating Additional Forms and Windows
- Creating a Multi-Document Interface (MDI) Application
08. Managing Database Changes and Create, Read, Update, Delete (CRUD) Operations
- Viewing Data in a Grid
- Managing Database Changes
- Creating and Editing Records (Using One Form)
- Vehicle Data Validations and Handling Exception
- Managing Car Rental Records
- Enhancing Application Flow and User Experience
09. User Management and Login Functionality
- Creating a Simple Login Form
- Control Features Based on User Roles
- User Password and Active Status Reset
- Adding New Users and Resetting Password
10. Adding to a Source Control
- Adding Project to GitHub
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Find out how to create desktop applications with C#
Connect Windows Forms applications to a database
Discover how to use C# operators for math and logic tasks
Handle database changes and manage create, read, update, and delete (CRUD) operations
Write Language Integrated Query (LINQ) to retrieve data from databases
Connect to and upload a project to GitHub
COURSE OUTLINE
01. Development Environment Setup
- Installing Visual Studio 2022 Community Edition
- Create Your First C# Console Project
- Visual Studio 2022 Community Edition Tour
- Understanding the Difference Between .NET 6 and Previous Versions
- Development Using Visual Studio Code
02. C# Console Programming – Basic Control Structures
- Understanding Basic C# Syntax
- Input and Output Programs
- C# Data Types and Conversion
- Application Debugging Techniques
- Arithmetic and Assignment Operators
- Conditional Statements
- Repetition Statements
03. C# Console Programming – More Advanced Concepts
- Methods – Void
- Methods – Value Returning
- String Manipulation Functions
- DateTime Manipulation Functions
- Exception Handling
- Arrays
- Lists
04. C# Console Programming – Object-Oriented Concepts
- Introduction to Classes and Objects
- Method Overloading
- Static Classes and Static Class Members
- Inheritance with Classes and Interfaces
- Constructors
05. Add Visual Studio Solution to GitHub
- Create GitHub Account
- Add Solution to Source Control
06. WinForms Applications – The Basics
- Visual Studio 2022 – Windows Forms Setup
- Creating a Simple WinForms Application (Car Rental Application)
- Understanding WinForms Controls, Properties, and Events
- Form Validation and Exception Handling
- Installing SQL Server Express Edition
- Creating a Database in a SQL Server
- Creating a Database Model with ADO.NET
- Selecting Data from the Database Using Language Integrated Query (LINQ)
- Submitting to Database from Form
07. Multi-Document Interface (MDI) and More Database Operations
- Creating Additional Forms and Windows
- Creating a Multi-Document Interface (MDI) Application
08. Managing Database Changes and Create, Read, Update, Delete (CRUD) Operations
- Viewing Data in a Grid
- Managing Database Changes
- Creating and Editing Records (Using One Form)
- Vehicle Data Validations and Handling Exception
- Managing Car Rental Records
- Enhancing Application Flow and User Experience
09. User Management and Login Functionality
- Creating a Simple Login Form
- Control Features Based on User Roles
- User Password and Active Status Reset
- Adding New Users and Resetting Password
10. Adding to a Source Control
- Adding Project to GitHub
