Free Source Code and Tutorials

Custom Search

How to Connect MySQL Database to

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


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.


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 in the method.

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

//initialize sql connection
 MySqlConnection con = new MySqlConnection();
 //set a connection string
 con.ConnectionString = "server=localhost;user id=root;password=;Database=dbconnect;";
 //opening connection
 //validating connection

 if (con.State == ConnectionState.Open)
 if (button1.Text == "Connect Me")
 button1.Text = "Disconnect Me";
 this.Text = "Connected";
 button1.Text = "Connect Me";
 this.Text = "Disconnected";


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



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


Download Source Code

Facebook Comments
(Visited 15 times, 1 visits today)
Share this

Check Your Domain Ranking

Leave a Reply

Your email address will not be published. Required fields are marked * © 2016 Frontier Theme

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!

%d bloggers like this: