CRUD application using C#, MySQL Server, Windows Forms.

CRUD application using C#, MySQL Server, Windows Forms., available at $44.99, has an average rating of 4.45, with 28 lectures, based on 25 reviews, and has 128 subscribers.

You will learn about C# programming using Windows Forms and MySQL Server as the database and where we will create an Application that can Create, Read, Update and Delete records. Keep the code to a minimum and as simple as possible You will gain skills using MySQL Server and MySQL Workbench to create, manage the databases, create Stored Procedures and also create users and Privileges.. You will feel more confident using C#, Windows Forms as well as handle MySQL Server 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 MySQL Server. It is particularly useful for Anyone that needs to understand how to create a CRUD database application using C#, Windows Forms, and MySQL Server.

Enroll now: CRUD application using C#, MySQL Server, Windows Forms.

Summary

Title: CRUD application using C#, MySQL Server, Windows Forms.

Price: $44.99

Average Rating: 4.45

Number of Lectures: 28

Number of Published Lectures: 28

Number of Curriculum Items: 28

Number of Published Curriculum Objects: 28

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

C# programming using Windows Forms and MySQL Server as the database and where we will create an Application that can Create, Read, Update and Delete records.
Keep the code to a minimum and as simple as possible
You will gain skills using MySQL Server and MySQL Workbench to create, manage the databases, create Stored Procedures and also create users and Privileges..
You will feel more confident using C#, Windows Forms as well as handle MySQL Server in many ways.

Who Should Attend

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

Target Audiences

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

This course (part 1) will have in total 11 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 2019 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. 10-12 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.

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

Course Curriculum

Chapter 1: Introduction to PART 1

Lecture 1: Introduction

Chapter 2: Download and Install Software

Lecture 1: Installation of Visual Studio 2019 Community Edition

Lecture 2: Installation of MySQL Server

Chapter 3: Creation of Database and a Stored Procedure (SP)

Lecture 1: Creation of the database using MySQL Workbench

Lecture 2: Import data/records to our new database

Lecture 3: Creation of the first Stored Procedure (BC_Get_All)

Lecture 4: A discussion around Stored Procedures

Lecture 5: Final discussion of Section 3 (SP)

Chapter 4: Creation of Our Project (Visual Studio)

Lecture 1: MySQL User Interface (UI) documentation

Lecture 2: Creation of the User Interface (UI)

Lecture 3: – Configuration of Visual Studio 2019

Chapter 5: Read Records from the Database

Lecture 1: Create the database connection using App.config

Lecture 2: Read Data from Database and present in DataGridView

Lecture 3: Catch Exception – When Application crashes

Lecture 4: Try & Catch for ReadData(). MessageBox when error is caught.

Chapter 6: DataGridView double-click event

Lecture 1: Double-Click Event

Chapter 7: Save Or Update Record in the Database

Lecture 1: Add and Update – Stored Procedure

Lecture 2: Update Record – Application

Lecture 3: Save New Record – Application

Chapter 8: Delete a record from the Database

Lecture 1: Delete Record – Stored Procedure and Application

Chapter 9: Helper methods and more…

Lecture 1: Initial discussion and show cases for Helper methods

Lecture 2: Clear Text Boxes

Lecture 3: Save and New Buttons

Lecture 4: Quit Button

Lecture 5: Messages Boxes and some Button behavior

Chapter 10: Search functionality

Lecture 1: Search – Stored Procedure

Lecture 2: Search – Application

Chapter 11: Wrap-up of this course (part 1)

Lecture 1: Wrap-Up of part 1

Instructors

Peder Thornstrom
Cyber Security Consultant

Rating Distribution

1 stars: 2 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 5 votes
5 stars: 16 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!

Menu