Csharp Winforms Sql Database

Learn how to program mid-size project with Create, Read, Update and Delete functionality with C#, Windows Forms, and SQL

Last updated 2022-01-10 | 4.3

- Working with multiple forms
- CRUD operation
- OOP C#

What you'll learn

Working with multiple forms
CRUD operation
OOP C#
Passing data between forms
Connecting Windows Forms to database
Windows Forms
Working with Windows Forms Events
SQL

* Requirements

* Visual Studio 2019
* Microsoft SQL Express
* 6+ months of C# programming experience
* Basic understanding of Windows Forms

Description

So what is the course all about? It’s about showing you how to set up mid-size project with Create, Read, Update and Delete functionality, C#, Windows Forms, and SQL. I don’t go over any theory, so it is advised you have a at least few months of experience with C# and Windows Forms.

The project itself is perfect for showing how to work with multiple forms, set up C# classes, connect to the database, code basic SQL statements, pass data between forms and form objects, work with Windows Form events, and perform CRUD operations. We won’t be working with in-memory data and each operation will be performed directly against the database.

Of course, this is not a full production ready project. However, it demonstrates how to build a mid-size Windows Forms application, and prepares you towards more advanced concepts. The goal is to show you step by step how each piece of application is coded, so that you can easily follow. This is a perfect course for people who prefer hands on programming, and who like to code everything in a single project, rather than lots of small examples. You can easily finish the project in one weekend, but don’t let that fool you - there is a lot packed into it, and once you understand the code and principles used in this project, you can definitely consider yourself an intermediate programmer. Not bad for 3 hours of your time, right?

So, I’ll see you in the course. Let’s code.

Who this course is for:

  • Beginner C# programmers
  • Programmers who prefer hands on programming
  • Students who prefer single project over mutliple small examples

Course content

10 sections • 38 lectures

Introduction to the Project Preview 05:32

Source Code Preview 00:17

Reviewing Forms Preview 02:24

Adding Data Set Preview 03:46

Adding SQL Table Adapters Preview 09:24

Creating Customer Class Preview 05:18

Getting Customer by ID Preview 04:58

Checking for Duplicate Phone Number Preview 05:54

Finding Customer By ID Preview 02:25

Inserting New Customer Preview 02:27

Updating Customer Preview 04:03

Deleting Customer Preview 04:19

Creating Class Preview 06:05

Finding Appointment by ID Preview 01:37

Getting Appointment Date and Time Preview 03:30

Inserting New Appointment Preview 03:02

Updating Appointment Preview 04:16

Deleting Appointment Preview 02:58

Customers Form - Modifying Customer Preview 07:36

Customers Form - Deleting Customer Preview 05:58

New Customer Form - Adding Customer Preview 06:25

Modify Customer Form - Modifying Customer Preview 07:37

Appointments Form - Showing All Appointments Preview 03:59

Appointments Form - Populating Drop Downs Preview 04:19

Appointments Form - Filtering Appointments By Customer Preview 03:51

Appointments Form - Updating Appointment Preview 03:57

Appointments Form - Deleting Appointment Preview 01:43

New Appointments Form - Populating Drop Downs Preview 03:50

New Appointments Form - Adding New Appointment Preview 06:25

Modify Appointment Form - Modify Appointment Preview 03:35

Modify Appointment Form - Load Event Preview 03:47

Testing and Finding Issues Preview 05:28

Fixing Deleting Customer With Appointment Exception Preview 05:46

Fixing Combo Boxes Bug Preview 07:44