Step 1: Add Reference of MySql.Data.dll

Step 2: Add a class file with named MYSQL.CS

Step 3: Add the following name space

using MySql.Data.MySqlClient;
using MySql.Data;

Step 4: Write the below code in cs file to check the connection is working or not.

public bool check_connection(string conn)

{

bool result = false;

MySqlConnection connection = new MySqlConnection(conn);

try

{

connection.Open();

result = true;

connection.Close();

}

catch

{

result = false;

}

return result;

}


Step 5: To use above function please write the below code.

Create instance of class:

MYSQL mysql = new MYSQL();

Use it in Button event or anywhere.

source_result = mysql.check_connection("Your connection String");

if (source_result == false)

{

lbl_error.Text = lbl_error.Text + " ::Error In Source Connection";

}