阿巴阿巴阿巴

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 System.Data.SqlClient;

namespace WindowsFormsApp2
{
    public partial class Form1 : Form
    {
        string connectionStr = "Data Source=DESKTOP-DQ03C8P;Initial Catalog=教务处;Integrated Security=True";
        DataSet myst = new DataSet();
        public Form1()
        {
            InitializeComponent();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(connectionStr);
            conn.Open();
            string selectsql = "update student set ssex = '" + textBox3.Text + "' where sname = '" + textBox2.Text + "'";
            SqlCommand cmd = new SqlCommand(selectsql, conn);
            cmd.CommandType = CommandType.Text;
            SqlDataReader sdr;
            sdr = cmd.ExecuteReader();
            this.DialogResult = System.Windows.Forms.DialogResult.Yes; 
            conn.Close();


            MessageBox.Show("更新成功！");
 
 
 


        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(connectionStr);
            conn.Open();
            //内连接 inner join，左连接 left，右连接 right，全连接 full，交叉连接 cross
            string commandText = "select * from [student] full  join [sc] on [student].Sno=[sc].Sno";
            using (SqlDataAdapter adapter = new SqlDataAdapter(commandText, connectionStr))
            {
                DataTable dataTable = new DataTable();
                adapter.Fill(dataTable);
                dataGridView1.DataSource = dataTable;
            }
            conn.Close();

        }

        private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(connectionStr);
            conn.Open();

            string MyDelete = "Delete from student where Sno=" + textBox1.Text;
            SqlCommand cmd = new SqlCommand(MyDelete, conn);
            cmd.CommandType = CommandType.Text;
            SqlDataReader sdr;
            sdr = cmd.ExecuteReader();
            this.DialogResult = System.Windows.Forms.DialogResult.Yes;

            conn.Close();


            MessageBox.Show("删除成功！");


        }
    }
}