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

Name: CRUD application using C#, MySQL Server, Windows Forms.
Rating: 4.5 (29 reviews)

How to create a CRDU application using MySQL Server and Stored Procedures

Created byPeder Thornstrom

Last updated 3/2022

English

What you'll 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.

Course content

11 sections • 28 lectures • 3h 59m total length

Introduction16:42

Creation of the database using MySQL Workbench14:22
Import data/records to our new database3:48
Import data into the new database using the table data import wizard with a CSV export file, mapping columns, and importing seven records for development.
Creation of the first Stored Procedure (BC_Get_All)5:13
learn to create the first stored procedure bc_get_all, return all records with select star from the table, and understand how stored procedures decouple code and enhance security.
A discussion around Stored Procedures10:17
Final discussion of Section 3 (SP)4:50

Create the database connection using App.config8:43
Learn how to configure a MySQL database connection in a C# Windows Forms app using app.config, define a connection string, fetch it with ConfigurationManager, and open and close the connection.
Read Data from Database and present in DataGridView10:12
Catch Exception – When Application crashes8:28
Try & Catch for ReadData(). MessageBox when error is caught.5:49

Initial discussion and show cases for Helper methods3:40
Explore helper methods to tidy a crud app in C#, MySQL server, and Windows Forms, including update, delete, and clearing textboxes with user messages, planning a stored procedure for search.
Clear Text Boxes8:52
Save and New Buttons6:17
Quit Button5:27
Implement a graceful quit with a quit button and a yes/no message box in Windows Forms. Initialize button states and handle the dialog result to exit on yes.
Messages Boxes and some Button behavior12:08

Requirements

There are no hard requirements but having programming in a C like language will be helpful.

Description

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.

Who this course is for:

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

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

What you'll learn

Explore related topics

Course content

Introduction to PART 11 lecture • 17min

Download and Install Software2 lectures • 22min

Creation of Database and a Stored Procedure (SP)5 lectures • 39min

Creation of Our Project (Visual Studio)3 lectures • 24min

Read Records from the Database4 lectures • 33min

DataGridView double-click event1 lecture • 12min

Save Or Update Record in the Database3 lectures • 26min

Delete a record from the Database1 lecture • 13min

Helper methods and more...5 lectures • 36min

Search functionality2 lectures • 12min

Requirements

Description

Who this course is for: