CRUD, C#, PostgreSQL Server, using Windows Forms
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 MySQL Server as the database. We will also be using Stored Procedures that will be executed by a specially defined user.
The course will expand to three parts where we will add another database in part 2. In part 3 we will add capability to use images/photos/logos that we will stored in the database itself. When all parts are complete it’ll extend to another approx. 14-15 sections.
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 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 MySQL Server.
Tools and development environment can be downloaded for free – full instructions inside this course regards to installation and configuration.
You can have a closer look at UDEMY to find a more detailed view of the content.
What you will learn
C# programming using Windows Forms and PostgreSQL Server as the database and where we will create an Application that can Create, Read, Update and Delete records (CRUD).
You will gain skills using PostgreSQL Server to create, import data, manage the databases, create Stored Procedures and also create users and set privileges for the user(s).
We will keep the code to a minimum and as simple as just possible
When you have completed this course you will feel more confident using C#, Windows Forms, as well as handle PostgreSQL Server in many ways.
Any course requirements or prerequisites?
There are no hard requirements but having programming in a C-like language will be helpful. The software we will use are all free and instructions of downloads and installation will be part of the course.
Who this course is for?
Anyone that needs to understand how to create a CRUD application using C# and Windows Forms. Visual Studio 2019 Community and MySQL Server will be used.
At the end of this course, you will be confident of writing your own CRUD applications using C# and PostgreSQL Server.
This is what you will build
After completing the Part 1 we will have a full CRUD application.
In this section we will add another database and import the records to it. We will then populate the ComboBox so we can select a country from a list of 195 countries. Here we will replace a TextBox with a ComboBox and do the required changes in the code.
Here we have now added the capability to add an image/photo/logo that will be converted and saved in the database. It will of course require some changes in the database and the User Interface.