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

来源：互联网发布：5c5c5c最新域名地址编辑：程序博客网时间：2024/06/05 08:16

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

阅读全文

0 0