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!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024