MySchool部分代码

来源：互联网发布：淘宝店铺如何开通花呗编辑：程序博客网时间：2024/05/05 17:33

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

namespace MySchool
{
    /// <summary>
    /// 教员信息列表窗体
    /// 学生用书第八章示例3
    /// </summary>
    public partial class TeacherListForm : Form
    {
        private DataSet dataSet = new DataSet();　　// 声明并初始化DataSet
        private SqlDataAdapter dataAdapter;　　　　 // 声明DataAdapter

        public TeacherListForm()
        {
            InitializeComponent();
        }

        // 窗体加载时填充数据
        private void TeacherListForm_Load(object sender, EventArgs e)
        {
            // 查询用的 sql 语句
            string teacherSql = "SELECT TeacherID,LoginId,LoginPwd,TeacherName,Sex,BirthDay FROM Teacher";

            // 初始化 DataAdapter
            dataAdapter = new SqlDataAdapter(teacherSql, DBHelper.connection);

// 填充 DataSet
dataAdapter.Fill(dataSet, "Teacher");

            // 绑定DataGridView的数据源
            dgvTeacher.DataSource = dataSet.Tables["Teacher"];
        }

        // 单击“保存修改”按钮时，将数据集的更改提交到数据库
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("确实要将修改保存到数据库吗?","操作提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
            if (result == DialogResult.OK)
            {
                SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter);
                dataAdapter.Update(dataSet, "Teacher");
            }
        }

        // 单击“关闭”按钮时,关闭窗体
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}