.NET连接mysql数据库 MySQLDriverCS.dll

 

 string mysqlConn = new MySQLConnectionString("localhost", "shopex", "root", "1").AsString;//注意这里不是tostring（）
            MySQLConnection conn = new MySQLConnection(mysqlConn);
conn.Open();
            MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
            commn.ExecuteNonQuery();       //设置set names gb2312   解决乱码
            MySQLDataAdapter da = new MySQLDataAdapter("select * from sdb_orders", conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            conn.Close();