mysql in c# code example

Example: c# select Mysql

DataSet ds = new DataSet();
using (MySqlConnection con = new MySqlConnection(connectionstr))
{
    using (MySqlCommand cmd = con.CreateCommand())
    {
        con.Open();
        cmd.CommandText = "select * from mysql.user;";
        MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
        adapter.Fill(ds);
    }
}