//设置表格数据调用方法 private void setStu_CourData() { string stuName = null; string courseName = null; DataSet dataSet = DAO_S_C.selectS_CData(stuName, courseName); dataGridView1.DataSource = dataSet.Tables["s_c"]; }
//设置搜索按钮点击事件 private void bt_select_Click(object sender, EventArgs e) { string stuName = isNull(tb_stuName.Text); string courseName = cb_className.SelectedValue.ToString(); DataSet dataSet = DAO_S_C.selectS_CData(stuName, courseName); dataGridView1.DataSource = dataSet.Tables["s_c"]; }
private void change_button_Click(object sender, EventArgs e) { bool result = DAO_S_C.updateS_C(tb_stuId.Text, tb_courseName.Text, tb_stuScore.Text); if (result) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败,请重试"); } }
private void change_button_Click(object sender, EventArgs e) { bool result = DAO_S_C.updateS_C(tb_stuId.Text, tb_ClassName.Text, tb_stuScore.Text); if (result) { MessageBox.Show("录入成功"); setStu_CourData(); } else { MessageBox.Show("录入失败,请重试"); } }
private void bt_add_Click(object sender, EventArgs e) { string courseName = cb_className.SelectedValue.ToString(); string stuId = tb_stuId.Text; bool result = DAO_S_C.choiceCourse(stuId, courseName); if (result) { MessageBox.Show("选课成功"); setStu_CourData(); } else { MessageBox.Show("选课失败,请重试"); } }