1.安装MySql for .net插件mysql-connector-net-5.0.8.1.exe,可从这里下载:
http://mysql.isu.edu.tw/Downloads/Connector-Net/?dir=/Unix/Database/MySQL/Downloads/Connector-Net&page=3
2.工程中引用MySql.Data命名空间.
3.代码如下:
using MySql.Data.MySqlClient;
private void button1_Click(object sender, EventArgs e)
{
string myConnectionString = "Database=DBtest;
Data Source=localhost;
User Id=root;
Password=sa;
charset=gb2312";
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
myConnection.Open();
string SqlStr = "select * from Table1";
MySqlDataAdapter Mda = new MySqlDataAdapter(SqlStr, myConnection);
DataSet Ds = new DataSet();
Mda.Fill(Ds);
dataGridView1.DataSource = Ds.Tables[0];
}
http://mysql.isu.edu.tw/Downloads/Connector-Net/?dir=/Unix/Database/MySQL/Downloads/Connector-Net&page=3
2.工程中引用MySql.Data命名空间.
3.代码如下:
using MySql.Data.MySqlClient;
private void button1_Click(object sender, EventArgs e)
{
string myConnectionString = "Database=DBtest;
Data Source=localhost;
User Id=root;
Password=sa;
charset=gb2312";
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
myConnection.Open();
string SqlStr = "select * from Table1";
MySqlDataAdapter Mda = new MySqlDataAdapter(SqlStr, myConnection);
DataSet Ds = new DataSet();
Mda.Fill(Ds);
dataGridView1.DataSource = Ds.Tables[0];
}