//设置表格数据调用方法
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("选课失败，请重试");
}
}
