C#连接MySql数据库

迈不过友情╰ 2022-07-14 06:57 175阅读 0赞

http://blog.csdn.net/friendan/article/details/9017685

MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.zip下载地址：

[http://download.csdn][http_download.csdn][.NET][]/download/friendan/5497971

其实文中用到的MySQLDriverCS.dll文件，在我[测试][Link 1]的例子程序中已经打包给大家了，

该例子程序在文章后面有下载地址。

\-----------------------------------------------------------------------------------------------------------------------

其实C\#连接[MySQL][][数据库][MySQL]，不是很难，关键是要把MySQLDriver.dll导入到工程的引用中。

\------------------------------------------------------------------------------------------------------------------------

先看下效果截图：

![20130603222215078][]

![20130603222233421][]

\--------------------------------------------------------------------------------------------------------

主要代码为：

**\[csharp\]**  [view plain][]   [copy][view plain]

[print][view plain] [?][view plain]

1.  **bool** ConnMySqlDb()  
2.          \{  
3.              **try**  
4.              \{  
5.                  MySQLConnection conn = **null**;  
6.                  conn = **new** MySQLConnection(  
7.                         **new** MySQLConnectionString(txbIp.Text.Trim(),  
8.                                                txbDb.Text.Trim(),  
9.                                                txbUser.Text.Trim(),  
10.                                               txbPass.Text.Trim()).AsString);  
11.                 conn.Open();  
12.                 MessageBox.Show("所连数据库为:"\+conn.Database);  
13.                 **return** **true**;  
14.             \}  
15.             **catch** (System.Exception ex)  
16.             \{  
17.                 MessageBox.Show(ex.ToString() + ex.Message);  
18.                 **return** **false**;  
19.             \}  
20.         \}

![save_snippets.png][]

\-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

# [C\#连接MySql例子程序.zip][C_MySql_.zip] #

[![cgi_get_user_pic_openid_00000000000000000000000005492D01_pic_1.jpg_key_14c00103d64a28b46e3a7211892ffbee][]][cgi_get_user_pic_openid_00000000000000000000000005492D01_pic_1.jpg_key_14c00103d64a28b46e3a7211892ffbee 1]

**您的十分满意是我追求的宗旨。**

**您的一点建议是我后续的动力。**

[http_download.csdn]: http://download.csdn.net/download/friendan/5497971
[.NET]: http://lib.csdn.net/base/dotnet
[Link 1]: http://lib.csdn.net/base/softwaretest
[MySQL]: http://lib.csdn.net/base/mysql
[20130603222215078]: /images/20220714/0f657ed7e9e84a6ca8ed8b26a61f58d3.png
[20130603222233421]: /images/20220714/b3557a16c87245eba650b270724f0399.png
[view plain]: http://blog.csdn.net/friendan/article/details/9017685#
[save_snippets.png]: /images/20220714/2d86ed8d46b446c1be45b0b6e2bcabe9.png
[C_MySql_.zip]: http://download.csdn.net/download/friendan/5511551
[cgi_get_user_pic_openid_00000000000000000000000005492D01_pic_1.jpg_key_14c00103d64a28b46e3a7211892ffbee]: /images/20220714/ca11f35d78d94937a4e2c83b6ba3cd07.png
[cgi_get_user_pic_openid_00000000000000000000000005492D01_pic_1.jpg_key_14c00103d64a28b46e3a7211892ffbee 1]: http://www.2345.com/?k78771625