public UpdateStuInfo(string id)
{
InitializeComponent();
setMajorData();
student stu = new student();
stu.StuId = id;
DataSet ds = DAO_Student.SelectStuData(stu);
DataTable dataTable = ds.Tables["student"];
tb_stuId.Text = id;
tb_stuName.Text = dataTable.Rows[0][1].ToString();
cb_stuGrade.Text = dataTable.Rows[0][3].ToString();
cb_stuMajor.Text = dataTable.Rows[0][4].ToString();
tb_stuHome.Text = dataTable.Rows[0][6].ToString();
tb_stuClass.Text = dataTable.Rows[0][5].ToString();
if (dataTable.Rows[0][2].ToString() == "女")
{
this.sex_gird.Checked = true;
}
else
{
this.sex_boy.Checked = true;
}
}
//设置学生表格数据
private void selectStuData()
{
student student = new student();
DataSet dataSet = DAO_Student.SelectStuData(student);
dgv_stuInfo.DataSource = dataSet.Tables["student"];
}
//设置选择班级下拉框数据
private void setClassData()
{
student student = new student();
DataSet ds = DAO_Student.SelectStuData(student);
DataTable dtGroup = ds.Tables["student"];
cb_className.DataSource = dtGroup;
cb_className.DisplayMember = "stuClassName";
cb_className.ValueMember = "stuClassName";
}
//修改学生按钮点击事件
private void bt_change_Click(object sender, EventArgs e)
{
student stu = new student();
string id = dgv_stuInfo.SelectedRows[0].Cells[0].Value.ToString();
UpdateStuInfo changeStuInfo = new UpdateStuInfo(id);
changeStuInfo.ShowDialog();
DataSet ds = DAO_Student.SelectStuData(stu);
DataTable dtGroup = ds.Tables["student"];
dgv_stuInfo.DataSource = dtGroup;
}
//查询按钮点击事件
private void bt_select_Click(object sender, EventArgs e)
{
student stu = new student();
if (tb_stuId.Text.Trim().Length != 0)
{
stu.StuId = tb_stuId.Text;
}
if (tb_stuName.Text.Trim().Length != 0)
{
stu.StuName = tb_stuName.Text;
}
if (cb_stuSex.SelectedIndex != -1)
{
stu.StuSex = cb_stuSex.SelectedItem.ToString();
}
stu.StuMajor = cb_major.SelectedValue.ToString();
stu.StuClassName = cb_className.SelectedValue.ToString();
DataSet ds = DAO_Student.SelectStuData(stu);
DataTable dtGroup = ds.Tables["student"];
dgv_stuInfo.DataSource = dtGroup;
}