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.
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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
//initialize sql connection MySqlConnection con = new MySqlConnection(); //set a connection string con.ConnectionString = "server=localhost;user id=root;password=;Database=dbconnect;"; //opening connection con.Open(); //validating connection if (con.State == ConnectionState.Open) { if (button1.Text == "Connect Me") { button1.Text = "Disconnect Me"; this.Text = "Connected"; } else { button1.Text = "Connect Me"; this.Text = "Disconnected"; con.Close(); } } |
5. Press F5 on the keyboard to run your project.
Output:
This is a simple yet powerful method to do because without this, you can’t proceed to the process of CRUD.