visual studio 2010 mysql_Visual Studio 2010连接mysql的方法

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)

 --Visual Studio 2010 - Server Explorer window

use Connect to Database button

in the Choose Data Source windows select MySql Database and press Continue

 --VS2010 - MySQL DataSource

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

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();

}