C# 数据库的连接

目录

要求：

一、连接MySQL（VS2022）

二、编写代码流程

1.设计界面

​编辑

2.引入库

3.与数据库进行连接

4.查询 

5.增加

6.删除

7.修改 

仓库地址

---

 

要求：

1.请设计一个项目连接到自己的MySQL数据库，数据库包含至少三张表；
2.使用dataGridView控件显示表中的数据；
3.实现基本crud操作；
 

一、连接MySQL（VS2022）

 

 

二、编写代码流程

1.设计界面

需要5个button及1个DataGridView

2.引入库

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

3.与数据库进行连接

private MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
        private MySqlConnection connection;

private void button1_Click(object sender, EventArgs e)
        {
      
                builder.UserID = "root";
                builder.Password = "nishizhende6";//密码
                builder.Server = "localhost";
                builder.Database = "student_course";//数据库名
                connection = new MySqlConnection(builder.ConnectionString);
                try
                {
                    //打开数据库连接
                    connection.Open();
                    MessageBox.Show("数据库已连接！");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
           
 }

如图所示

4.查询 

private void button5_Click(object sender, EventArgs e)
        {
            string sql = "select * from Student";
            MySqlDataAdapter mda = new MySqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            mda.Fill(ds, "Student");
            dataGridView1.DataSource = ds.Tables["Student"];

        }

5.增加

 private void button2_Click(object sender, EventArgs e)
        {
            string sql = "insert into Student values('201225311','张未','男','19','PE')";
            string sql1 = "insert into Student values('201225231','刘经','男','20','PE')";
            MySqlDataAdapter mda = new MySqlDataAdapter(sql, connection);
            MySqlDataAdapter mda1 = new MySqlDataAdapter(sql1, connection);
            DataSet ds = new DataSet();
            mda.Fill(ds, "Student");
            mda1.Fill(ds, "Student");

        }

如图所示 

 

6.删除

private void button3_Click(object sender, EventArgs e)
        {
            string sql = "delete from Student where Sname='张强'";
            MySqlDataAdapter mda = new MySqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            mda.Fill(ds, "Student");

        }

如图所示 

7.修改 

private void button4_Click(object sender, EventArgs e)
        {
            string sql = "update Student set Sage = '25' where Sname='王五'";
            MySqlDataAdapter mda = new MySqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            mda.Fill(ds, "Student");

        }

如图所示

 

仓库地址

test1: LPS秃头版的第一个仓库，希望卒或有所闻 (gitee.com)