How to Connect MySQL Database to C#.net

0
1210

In this tutorial, I will teach you how to connect MySQL Database to C#.net using Microsoft Visual Studio 2008. With this, you can establish a connection between MySQL Database and C#.net.

 

Let’s begin:

 

1. Create a database in the MySQL and name it “dbconnect

2. Open Microsoft Visual Studio and create a new windows form application for C#. Then, drag a button and do the form just like this.

ConnectionMySQLCsharp.fig.1

3. Double-click a button to fire the click event handler of it.

4. After that, do the following codes to established a connection between MySQL Database and C#.net in the method.

Note: Add “MySQL.Data.dll” as your refernce and put “using MySql.Data.MySqlClient; above the namespace to access MySQL library.

5. Press F5 on the keyboard to run your project.

Output:

ConnectionMySQLCsharp.fig.2

This is a simple yet powerful method to do because without this, you can’t proceed to the process of CRUD.

 

Download Source Code

Looking for more source code? Type your keyword here here!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.