欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

C#连接mysql (vs2010)

程序员文章站 2023-12-24 21:40:03
...

在vs2010中 工具-数据库连接 里要想连接到mysql数据库,需要安装这样一个东西: MySql Connector;1.首先安装 connector 。下载地址:(http://www.mysql.com/downloads/connector/net/)2.现在就可以了,打开vs2010试试吧! 安装完成后找到安装目录下(C:\Pr

在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,需如下code:

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

上一篇:

下一篇: