Introduction

This article shows you how to connect to a MySQL database using the MySQL Connector for .NET. I will also show you how to update MySQL database records using C#.

The prerequisites for running the sample are

Getting Started

Run the XAMPP application; it will automatically install the Apache Server, MySQL database, and FileZilla. After installation check whether these services are running or not. The following XAMPP control panel shows which of those services are currently running.

MySql1.jpg

Now the following steps will show how to connect to the MySQL database using C#.Net.

Step 1

Open the MySQL Admin page and create a new database.

MySql2.jpg

Step 2

After creating a new database, create a new table.

MySql2.5.jpg

Step 3

After creating the new table, open Visual Studio and click on the new project and give the project a name; it will open the new project, then click on the solution explorer (F4); right-click on "Reference" to add a new reference into the project. Add a reference for those two .dll files to the project (MySql.dll (Win apps), MySql.web.dll (Web apps)).

MySql3.jpg

Step 4

Add the namespace to the project.

MySql4.jpg

Step 5

Create a MySQL connection string.

MySql5.jpg

Step 6

The following code will insert the data into the MySQL table.

MySql6.jpg

Step 7

The following function will load the data from the table and bind it into the grid view.

MySql7.jpg

Step 8

The final result is shown in the following form.

MySql8.jpg

Conclusion

In this article, we learned about connecting to MySQL Using C#.NET.