MySQL with gridview

please explain your exact issue, in order to fetch data or to communicate with MySql you need to install,

MySql Connector for .Net, assuming that you have already installed the correct version of MySql Connector/Net

here is the code

using System;  
using System.Data;  
  
using MySql.Data;  
using MySql.Data.MySqlClient;  
  
public void BindGrid  
{  
    string connStr = "server=localhost;user=root;database=world;port=3306;password=******";  
    Using(MySqlConnection conn = new MySqlConnection(connStr))  
    {  
        Console.WriteLine("Connecting to MySQL...");  
        conn.Open();  
  
        string sql = "SELECT * FROM Country WHERE Continent='Oceania'";  
        MySqlCommand cmd = new MySqlCommand(sql, conn);  
        MySqlDataReader rdr = cmd.ExecuteReader();  
        GridView1.DataSource= rdr;  
        GridView1.DataBind();     
    }
}  

Namespaces used:- 

• System.Data; 
• MySql.Data;
• MySql.Data.MySqlClient;