C#学习笔记之C#调用MySql数据库

1、先在网上下载一个C#连接MySql需要使用的动态库：MySql.Data.dll

2、然后引用该动态库：

3、然后添加名称空间：

4、最后，通过代码测试：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using MySql.Data.MySqlClient;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        // 查询
        private void button1_Click(object sender, EventArgs e)
        {
            // 数据库连接字符串
            string strConn = "server=localhost; user id=root; password=root; port=3306; database=hib_demo; charset=utf8";
            // 数据库连接对象
            MySqlConnection myConn = new MySqlConnection(strConn);

            if (myConn.State == ConnectionState.Closed)
            {
                // 打开数据库连接
                myConn.Open();
            }

            // sql语句
            string sql = "select * from t_user";
            // 数据库指令对象
            MySqlCommand cmd = new MySqlCommand(sql, myConn);
            // 执行sql语句，并获取结果
            MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            // 循环遍历结果
            while (reader.Read()) 
            {
                string id = reader[0].ToString();
                string name = reader[1].ToString();
                string pwd = reader[2].ToString();
            }

            myConn.Close();
        }

        // 增加
        private void button2_Click(object sender, EventArgs e)
        {
            string strConn = "server=localhost; user id=root; password=root; port=3306; database=hib_demo";
            MySqlConnection myConn = new MySqlConnection(strConn);

            myConn.Open();

            string sql = "insert into t_user(t_name, t_pwd) values('zhangsan', 'zs123')";
            MySqlCommand cmd = new MySqlCommand(sql, myConn);

            int num = cmd.ExecuteNonQuery();
            
            myConn.Close();
        }

        // 更新
        private void button3_Click(object sender, EventArgs e)
        {
            string strConn = "server=localhost; user id=root; password=root; port=3306; database=hib_demo";
            MySqlConnection myConn = new MySqlConnection(strConn);

            myConn.Open();
            
            string sql = "update t_user set t_name='wangwu', t_pwd='ww' where t_id='3'";
            MySqlCommand cmd = new MySqlCommand(sql, myConn);
            int num = cmd.ExecuteNonQuery();

            myConn.Close();
        }

        // 删除
        private void button4_Click(object sender, EventArgs e)
        {
            string strConn = "server=localhost; user id=root; password=root; port=3306; database=hib_demo";
            MySqlConnection myConn = new MySqlConnection(strConn);

            myConn.Open();
        
            string sql = "delete from t_user where t_id = '3'";
            MySqlCommand cmd = new MySqlCommand(sql, myConn);
            int num = cmd.ExecuteNonQuery();

            myConn.Close();
        }
    }
}