c#开发数据库第四章上机题3-4

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;  

namespace WindowsFormsApplication1
{
    class DBHelper
    {
        private string connString = @"Data Source=.;Initial Catalog=MySchool;Integrated Security=True";

        // 数据库连接 Connection 对象  
        private SqlConnection connection;

        /// <summary>  
        /// Connection对象  
        /// </summary>  
        public SqlConnection Connection
        {
            get
            {
                if (connection == null)
                {
                    connection = new SqlConnection(connString);
                }
                return connection;
            }
        }

        /// <summary>  
        /// 打开数据库连接  
        /// </summary>  
        public void OpenConnection()
        {
            if (Connection.State == ConnectionState.Closed)
            {
                Connection.Open();
            }
            else if (Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
                Connection.Open();
            }
        }

        public void CloseConnection()
        {
            if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
            }
        }  
    }
}




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 WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            AddUser(); 
        }

        DBHelper db = new DBHelper();  
         public void AddUser()  
        {  
            string strsql=("SELECT  [StudentNo],[StudentName],[Sex],[GradeId] FROM [Student]");  
  
            try  
            {  
                SqlCommand comm = new SqlCommand(strsql, db.Connection);  
                db.OpenConnection();  
                SqlDataReader reader = comm.ExecuteReader();  
                while (reader.Read())  
                {  
                    string studentNo = reader["studentNo"].ToString();  
                    string studentName = reader["studentName"].ToString();  
                    string sex = reader["Sex"].ToString();  
                    int gradeId = Convert.ToInt32(reader["GradeId"]);  
                    string grade = string.Empty;  
                    if (gradeId == 1)  
                    {  
                        grade = "S1";  
                    }  
                    else if (gradeId == 2)  
                    {  
                        grade = "S2";  
                    }  
                    else  
                    {  
                        grade = "Y2";