CRUD application using C#, PostgreSQL, Windows Forms

CRUD application using C#, PostgreSQL, Windows Forms, available at $54.99, has an average rating of 4, with 25 lectures, based on 19 reviews, and has 82 subscribers.

You will learn about C# programming using Windows Forms and PostgreSQL as the db server and where we will create an application that can Create, Read, Update and Delete Records. We will keep the code to a minimum and as simple as possible. You will gain skills using PostgreSQL and pgAdmin 4 to create and manage the databases, create a Stored Procedure and also create users and their privileges . You will feel confident using C#, Windows Forms as well as handle PostgreSQL in many ways. This course is ideal for individuals who are Anyone that needs to understand how to create a CRUD database application using C#, Windows Forms, and PostgreSQL Server. It is particularly useful for Anyone that needs to understand how to create a CRUD database application using C#, Windows Forms, and PostgreSQL Server.

Enroll now: CRUD application using C#, PostgreSQL, Windows Forms

Summary

Title: CRUD application using C#, PostgreSQL, Windows Forms

Price: $54.99

Average Rating: 4

Number of Lectures: 25

Number of Published Lectures: 25

Number of Curriculum Items: 25

Number of Published Curriculum Objects: 25

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

C# programming using Windows Forms and PostgreSQL as the db server and where we will create an application that can Create, Read, Update and Delete Records.

We will keep the code to a minimum and as simple as possible.

You will gain skills using PostgreSQL and pgAdmin 4 to create and manage the databases, create a Stored Procedure and also create users and their privileges .

You will feel confident using C#, Windows Forms as well as handle PostgreSQL in many ways.

Who Should Attend

Anyone that needs to understand how to create a CRUD database application using C#, Windows Forms, and PostgreSQL Server.

Target Audiences

Anyone that needs to understand how to create a CRUD database application using C#, Windows Forms, and PostgreSQL Server.

This course (part 1) will have in total 12 sections.

The course will give you the knowledge of how to use C# to build a full CRUD application using Windows Forms. We will be using Visual Studio 2022 Community edition and create this CRUD application with PostgreSQL Server as the database. We will also create a Stored Procedure to populate our database with records.
In the Part 1 we will use SQL-statements in our source code to perform the database operations.

In Part 2 wee will add another database and also implement Stored Procedures / Function to replace all the SQL-statements in our source code.

In part 3 we will add capability to use images/photos/logos that we will stored in the database itself.

You will find a number of downloads in some of the section /lectures that will help you with some details and definitions. At the end of the course (section 12/Part 1), you will also find the source code itself for download.

Tools and development environment can be downloaded for free – full instructions inside this course regards to installation and configuration. You can find more detailed information on my BLOG. See my instructor page for the link.

At the end of this course, you will be confident of writing your own CRUD applications using C# and PostgreSQL Server.

You can also contact me in different ways to have some support, if needed.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Download and Installation of the Software

Lecture 1: Download and installation of PostgreSQL and Visual Studio

Lecture 2: Configuration of PostgreSQL

Lecture 3: : Configuration of Visual Studio 2022

Chapter 3: Configuration of our software

Lecture 1: Configuration of PostgreSQL Server

Lecture 2: Configuration of Visual Studio 2022

Lecture 3: Connection string (App.config) Visual Studio 2022

Chapter 4: Database Table and Stored Procedure creation

Lecture 1: Database Table creation

Lecture 2: Stored Procedure creation and insertion of Data

Chapter 5: Read Records from database and display in the DataGridView

Lecture 1: READ – read records from database to DataGridView

Chapter 6: User Interface (UI)

Lecture 1: User Interface prep talk

Lecture 2: Lecture 12: Build the User Interface (UI) – no sound

Lecture 3: Walk-through of UI and naming all controls

Lecture 4: UI – Wrap-up

Chapter 7: Populate records to the UI (User Interface)

Lecture 1: Lecture 15: Populate records to all textboxes

Chapter 8: Clear All Textboxes

Lecture 1: Lecture 16:

Chapter 9: Save, Update, and Delete

Lecture 1: Save record

Lecture 2: Update record

Lecture 3: Delete record

Chapter 10: Business Logic – Application behaviour

Lecture 1: Lecture 20:

Lecture 2: Business Logic – Textboxes and buttons 2

Lecture 3: Business Logic – Buttons 1

Lecture 4: Business Logic – Buttons 2

Chapter 11: Search Functionality

Lecture 1: Search Functionality

Chapter 12: Wrap-up of Part 1

Lecture 1: Wrap-up

Instructors

Peder Thornstrom
Cyber Security Consultant

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 2 votes

4 stars: 8 votes

5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!