参考http://www.itcsolutions.eu/2010/09/09/how-to-connect-to-mysql-database-from-visual-studio-vs2010-problems-with-net-connectors/
in order to connect to a MySql database from VS2010 you need to
- download the latest version of the MySql Connector/NET from http://www.mysql.com/downloads/connector/net/
- install the connector (if you have an older version you need to remove it from Control Panel -> Add / Remove Programs)
- open Visual Studio 2010
- open Server Explorer Window (View -> Server Explorer)
- use Connect to Database button
- in the Choose Data Source windows select MySql Database and press Continue
- in the Add Connection window
- set server name: 127.0.0.1 or localhost for MySql server running on local machine or an IP address for a remote server
- username and password
- if the the above data is correct and the connection can be made, you have the possibility to select the database
![VS2010 MySQL Connection properties VS2010 MySQL Connection properties](https://i-blog.csdnimg.cn/blog_migrate/d371b43bc33783972aa41683e02e8e9c.jpeg)
VS2010 MySQL Connection properties
If you want to connect to a MySql database from a C# application (Windows or Web) you can use the next sequence:
//define the connection reference and initialize it MySql.Data.MySqlClient.MySqlConnection msqlConnection = null; msqlConnection = new MySql.Data.MySqlClient.MySqlConnection(“server=localhost;user id=UserName;Password=UserPassword;database=DatabaseName;persist security info=False”); //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); //define the connection used by the command object msqlCommand.Connection = this.msqlConnection; //define the command text msqlCommand.CommandText = "SELECT * FROM TestTable;"; try { //open the connection this.msqlConnection.Open(); //use a DataReader to process each record MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { //do something with each record } } catch (Exception er) { //do something with the exception } finally { //always close the connection this.msqlConnection.Close(); }