4.第二章.上机1-3

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;

namespace WindowsFormsApplication2
{
    public partial class MySchool : Form
    {
        public MySchool()
        {
            InitializeComponent();
        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            MySchool_管理员 x = new MySchool_管理员();
            x.Show();
        }
    }
}

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;

namespace WindowsFormsApplication2
{
    public partial class MySchool_管理员 : Form
    {
        public MySchool_管理员()
        {
            InitializeComponent();
        }

        private void MySchool_管理员_Load(object sender, EventArgs e)
        {
            
        }

        private void 编辑学生信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {
MySchool_编辑学生信息 z = new MySchool_编辑学生信息();
            z.MdiParent = this;
            z.Show();
        }
    }
}













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 WindowsFormsApplication2
{
    public partial class MySchool_编辑学生信息 : Form
    {
        public MySchool_编辑学生信息()
        {
            InitializeComponent();
        }
        public bool BG() {
            DBHelper awe = new DBHelper();
            try
            {
                string sql = "SELECT * FROM [Grade]";
                awe.OpenConnection();
                SqlCommand command = new SqlCommand(sql, awe.Connection);
                SqlDataReader myReader = command.ExecuteReader();
                while (myReader.Read())
                {
                    string gradeName = myReader["GradeName"].ToString();
                    comboBox1.Items.Add(gradeName);

                }
                myReader.Close();
                return true;
            }
            catch (Exception)
            {
                MessageBox.Show("系统发生错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;

            }
            finally {
                awe.CloseConnection();
            }
        
        }
        private void MySchool_编辑学生信息_Load(object sender, EventArgs e)
        {
            BG();
        }