mysql datagridview_C#从MySQL读取数据到DataGridView

一、安装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();

}

}