semester.cs

学生管理（包括学生成绩 档案和课程） 学生可以录入数据

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace StudentManager
{
    public partial class Semester : Form
    {
        private SqlConnection conn1 = null;
        private SqlDataAdapter sqlDataAdapter1 = null;
        private DataSet DataSetDep = new DataSet("Semester");
        private string selectStr;		
        public Semester()
        {
            InitializeComponent();
            conn1 = new SqlConnection(DataLevel.Connection.ConnString);
            selectStr="select * from Semester";
            sqlDataAdapter1 = new SqlDataAdapter(selectStr, this.conn1);
            conn1.Open();
            this.sqlDataAdapter1.Fill(this.DataSetDep, "Semester");
            DataSet_Bingding();
            Buttons_Control(false);

        }
        private void DataSet_Bingding()
        {
            this.dataGridView1.DataSource = this.DataSetDep;
            this.dataGridView1.DataMember = "Semester";
            this.textSemID.DataBindings.Add("Text", this.DataSetDep, "Semester.SemesterID");
            this.textSemName.DataBindings.Add("Text",this.DataSetDep,"Semester.SemesterName");
        }
        private void Buttons_Control(bool IsValid)
        {
            if (IsValid)
            {
                this.btnCancel.Enabled = true;
                this.btnApply.Enabled = true;
                this.textSemID.Enabled = true;
                this.textSemName.Enabled = true;
      
            }
            else
            {
                this.btnCancel.Enabled = false;
                this.btnApply.Enabled = false;
                this.textSemID.Enabled = false;
                this.textSemName.Enabled = false;
     
            }
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            Buttons_Control(true);
            this.BindingContext[this.DataSetDep, "Semester"].AddNew();
        }

        private void btnApply_Click(object sender, EventArgs e)
        {
            if (textSemID.Text == "")
            {
                MessageBox.Show(" 学期代码不能为空 ！否则不能成功添加数据 ！");
                return;
            }
            this.BindingContext[this.DataSetDep,"Semester"].EndCurrentEdit();
            if(conn1.State==ConnectionState.Closed)
                conn1.Open();
          //  SqlCommandBuilder commandbuilder1=new SqlCommandBuilder(this.sqlDataAdapter1);
            this.sqlDataAdapter1.Update(this.DataSetDep,"Semester");
            this.DataSetDep.AcceptChanges();
            this.dataGridView1.Refresh();
            Buttons_Control(false);
           
        }

        private void btnModify_Click(object sender, EventArgs e)
        {
            this.Buttons_Control(true);
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (this.BindingContext[this.DataSetDep, "Semester"].Count > 0 &&
                (MessageBox.Show("真的要删除此记录吗 ?", "确定删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Question).Equals(DialogResult.OK)))
            {
                int position = this.BindingContext[this.DataSetDep, "Semester"].Position;
                this.BindingContext[this.DataSetDep, "Semester"].RemoveAt(position);
                this.BindingContext[this.DataSetDep, "Semester"].EndCurrentEdit();
                if (conn1.State == ConnectionState.Closed)
                    conn1.Open();
                SqlCommandBuilder commandbuilder1 = new SqlCommandBuilder(this.sqlDataAdapter1);
                this.sqlDataAdapter1.Update(this.DataSetDep, "Semester");
                this.DataSetDep.AcceptChanges();
                this.dataGridView1.Refresh();
                Buttons_Control(false);
            }
            else
                return;
            
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.DataSetDep, "Semester"].CancelCurrentEdit();
            Buttons_Control(false);
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

    }
}