1.安装mysql;
2.安装mysql-connector-net-6.6.4 点击下载(需要.net framework 4支持)
3.在工程中添加引用MySql.Data.dll
4.代码中添加using MySql.Data.MySqlClient;
5.剩下的就和mssql的操作一样了只是连接字符串有一些区别。
--------------------------------------------------------------------------------------------------------------------------------------
重要代码如下:(均为常用代码,因此不做注释)
MySqlConnection mySqlCon = new MySqlConnection("User Id=root;PassWord=123456789;Host=localhost;Database=mysql;");
MySqlCommand mySqlCmd = new MySqlCommand("select * from user", mySqlCon);
MySqlDataAdapter myDa = new MySqlDataAdapter(mySqlCmd);
DataSet ds = new DataSet();
mySqlCon.Open();
myDa.Fill(ds, "user");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
mySqlCon.Close();