C#从MySQL读取数据到DataGridView

http://www.oschina.net/translate/how-to-connect-to-mysql-using-csharp

http://hi.baidu.com/shuye216/item/efcec63b6869d1c02e8ec2c8

http://www.cnblogs.com/shylx123/archive/2010/09/29/1856944.html

一、安装MySql Connector

二、引用MySql.Data.dll并重新生成解决方案

三、添加using MySql.Data.MySqlClient，再次生成解决方案，如果有问题，考虑所引入的MySql.Data.dll版本是否不对，尝试其它的版本，直到生成解决方案成功。

四、读取数据库表格数据

	string MyConnectionString = "Server=localhost;Database=testdb;Uid=root;Pwd=199032;";                MySqlConnection connection = new MySqlConnection(MyConnectionString);                connection.Open();                try                {                    MySqlCommand cmd1 = connection.CreateCommand();                    cmd1.CommandText = "SELECT * FROM propertitydata";                    MySqlDataAdapter adap1 = new MySqlDataAdapter(cmd1);                    DataSet ds1 = new DataSet();                    adap1.Fill(ds1);                    dataGridView4.DataSource = ds1.Tables[0].DefaultView;                    MySqlCommand cmd2 = connection.CreateCommand();                    cmd2.CommandText = "SELECT * FROM polymer";                    MySqlDataAdapter adap2 = new MySqlDataAdapter(cmd2);                    DataSet ds2 = new DataSet();                    adap2.Fill(ds2);                    dataGridView5.DataSource = ds2.Tables[0].DefaultView;                }                catch (System.Exception ex)                {                    throw;                }                finally                {                    if (connection.State == ConnectionState.Open)                    {                        connection.Close();                    }                }