C#连接mysql (vs2010)

在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:

<span>//define the connection reference and initialize it</span>

 MySql.<span>Data</span>.<span>MySqlClient</span>.<span>MySqlConnection</span> msqlConnection <span><strong>=</strong></span> <span><strong>null</strong></span><span><strong>;</strong></span>

 msqlConnection <span><strong>=</strong></span> <span><strong>new</strong></span> MySql.<span>Data</span>.<span>MySqlClient</span>.<span>MySqlConnection</span><span><strong>(</strong></span>“<span><strong>server</strong></span><span><strong>=</strong></span>localhost<span><strong>;</strong></span>user id<span><strong>=</strong></span>UserName<span><strong>;</strong></span>Password<span><strong>=</strong></span>UserPassword<span><strong>;</strong></span>database<span><strong>=</strong></span>DatabaseName<span><strong>;</strong></span>persist security info<span><strong>=</strong></span><span><strong>False</strong></span>”<span><strong>)</strong></span><span><strong>;</strong></span>

 <span>//define the command reference</span>

 MySql.<span>Data</span>.<span>MySqlClient</span>.<span>MySqlCommand</span> msqlCommand <span><strong>=</strong></span> <span><strong>new</strong></span> MySql.<span>Data</span>.<span>MySqlClient</span>.<span>MySqlCommand</span><span><strong>(</strong></span><span><strong>)</strong></span><span><strong>;</strong></span>

 <span>//define the connection used by the command object</span>

 msqlCommand.<span>Connection</span> <span><strong>=</strong></span> this.<span>msqlConnection</span><span><strong>;</strong></span>

 <span>//define the command text</span>

 msqlCommand.<span>CommandText</span> <span><strong>=</strong></span> <span>"SELECT * FROM TestTable;"</span><span><strong>;</strong></span>

 try

<span><strong>{</strong></span>

 <span>//open the connection</span>

 this.<span>msqlConnection</span>.<span>Open</span><span><strong>(</strong></span><span><strong>)</strong></span><span><strong>;</strong></span>

 <span>//use a DataReader to process each record</span>

 MySql.<span>Data</span>.<span>MySqlClient</span>.<span>MySqlDataReader</span> msqlReader <span><strong>=</strong></span> msqlCommand.<span>ExecuteReader</span><span><strong>(</strong></span><span><strong>)</strong></span><span><strong>;</strong></span>

<span><strong> while</strong></span> <span><strong>(</strong></span>msqlReader.<span>Read</span><span><strong>(</strong></span><span><strong>)</strong></span><span><strong>)</strong></span>

 <span><strong>{</strong></span>

 <span>//do something with each record</span>

 <span><strong>}</strong></span>

<span><strong>}</strong></span>

catch <span><strong>(</strong></span>Exception er<span><strong>)</strong></span>

<span><strong>{</strong></span>

 <span>//do something with the exception</span>

<span><strong>}</strong></span>

finally

<span><strong>{</strong></span>

<span> //always close the connection</span>

 this.<span>msqlConnection</span>.<span>Close</span><span><strong>(</strong></span><span><strong>)</strong></span><span><strong>;</strong></span>

<span><strong>}</strong></span>