Hi
To communicate with mysql you need to add mysql.data.dll in your project
You can download this dll from
Here
after that add the namespace
using MySql.Data.MySqlClient;
MySqlConnection conn = new MySqlConnection(connectionstring);
MySqlCommand cmd = new MySqlCommand("Your sql query");
MySqlDataReader dr=cmd.ExecuteReader();
gridview1.datasource=dr;
gridview1.databind();
your connection string will be like this
<connectionstrings>
<add name="connectionstring" connectionstring="Data source=server;database=mydb;user id=root;password=1234" providername="MySql.Data.MySqlClient" />
</connectionstrings>
If you need documentation
Click Here
I hope this will help you....