c#连接mysql

MySqlConnection conn = new MySqlConnection("User Id=root;PassWord=sa;Host=localhost;Database=mis;");
conn.Open();
MySqlDataAdapter da = new MySqlDataAdapter("select id, name, age from `mis`.`users` ",conn);
DataSet ds = new DataSet();
da.Fill(ds,"users");
conn.Close();
DataGrid1.DataSource= ds;
DataGrid1.DataBind();

原文地址:https://www.cnblogs.com/zhenmingliu/p/2316123.html