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);
}
}