vs2010如何连接MySQL数据库过程分享

string str = "Server=127.0.0.1;User ID=root;Password=123456;Database=test;CharSet=gbk;";

           MySqlConnection con = new MySqlConnection(str);//实例化链接

           con.Open();//开启连接

           string strcmd = "select * from user";

           MySqlCommand cmd = new MySqlCommand(strcmd, con);

           MySqlDataAdapter ada = new MySqlDataAdapter(cmd);

           DataSet ds = new DataSet();

           ada.Fill(ds);//查询结果填充数据集

           dataGridView1.DataSource = ds.Tables[0];

           con.Close();//关闭连接