C# 连接mysql数据库(Visual Studio)

以你之姓@ 2022-02-14 00:47 389阅读 0赞

下载：MySql.Data.dll 文件

网址：[https://dev.mysql.com/downloads/windows/visualstudio/][https_dev.mysql.com_downloads_windows_visualstudio]

网盘： [https://pan.baidu.com/s/1FlLqnbwD3VBEdwz0\_4mZZw][https_pan.baidu.com_s_1FlLqnbwD3VBEdwz0_4mZZw] 提取码: k308

下载步骤：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 2][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 3][]

选择相应版本文件夹中的 MySql.Data.dll 文件（可以放置到项目文件夹中）

项目右击 -> 添加 -> 引用

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 4][]

浏览 -> 选择你下载的 MySql.Data.dll

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 5][]

连接数据库测试：

using MySql.Data.MySqlClient;
    
    //连接 "localhost; user = ***; database = world; port = 3306; password = ***; database=***"
    
    string conn = "server=localhost;user id=root;password=ren123456;database=student";
    MySqlConnection mysql_conn = new MySqlConnection(conn);
    mysql_conn.Open();
    
    string sql = "insert into sinfo values('010','张国荣','02')";
    MySqlCommand mysql = new MySqlCommand(sql, mysql_conn);
    int num = (int)mysql.ExecuteNonQuery();

[https_dev.mysql.com_downloads_windows_visualstudio]: https://dev.mysql.com/downloads/windows/visualstudio/
[https_pan.baidu.com_s_1FlLqnbwD3VBEdwz0_4mZZw]: https://pan.baidu.com/s/1FlLqnbwD3VBEdwz0_4mZZw
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190425152029350.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 1]: /images/20220214/9c76f7a1bc894d01b30bacc4525196ec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190425152100781.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 3]: /images/20220214/e18ced1d56a44e34ba6f334e95162a2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 4]: /images/20220214/3eced0983d934fd999cd47f0549cd08a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk5ODQw_size_16_color_FFFFFF_t_70 5]: /images/20220214/2e31eec22aa6477f9f996e94ee4ef1e6.png