C#连接mysql的方法【基于vs2010】

这篇文章主要介绍了C#连接mysql的方法,基于vs2010平台较为详细的讲述了C#操作mysql所需的组件下载、安装及连接mysql操作实现代码,需要的朋友可以参考下

本文实例讲述了C#连接mysql的方法。分享给大家供大家参考，具体如下：

在vs2010中工具->数据库连接里要想连接到MySQL数据库，需要安装这样一个东西： MySql Connector；

1.首先安装 connector 。下载地址：（http://www.mysql.com/downloads/connector/net/）

2.现在就可以了，打开vs2010试试吧！

安装完成后找到安装目录下(C:\Program Files\MySQL\MySQL Connector Net 6.4.4\Assemblies\v4.0\MySql.Data.dll,添加引用到工程中.

现在一切就OK了！

如果想在工程c#中连接mysql，需如下代码:

				?

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

									}