private void button1_Click(object sender, EventArgs e) { string sqlStr = "update Student_course set Score = " + textBox2.Text + " where id='" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'"; int Succnum = MyTool.executeCommand(sqlStr); if (Succnum > 0) { MessageBox.Show("录入成功"); } StudentList_SelectedIndexChanged(sender, e); }
private void button2_Click(object sender, EventArgs e) { if (MessageBox.Show("您确认要删除该记录吗?", "确认", MessageBoxButtons.YesNoCancel) == DialogResult.Yes) { string sqlStr = "update Student_course set Score=null where id='" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'"; int Succnum = MyTool.executeCommand(sqlStr); if (Succnum > 0) { MessageBox.Show("删除成功"); } StudentList_SelectedIndexChanged(sender, e); } }
private void button1_Click(object sender, EventArgs e) { string studentId = MyTool.getStudentIdByStudentName(StudentList.Text); string courseId = MyTool.getCourseIdByCourseName(CourseList.Text); string sqlStr = "insert into Student_course(Student_id,Course_id) values ('" + studentId + "','" + courseId + "')"; int Succnum = MyTool.executeCommand(sqlStr); if (Succnum > 0) { MessageBox.Show("录入成功"); } StudentList_SelectedIndexChanged(sender, e); }