public int stu_choose_course_insert(choose_course choo1) { conn.Open(); comm = new SqlCommand("stu_choose_course_insert", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@course_id", choo1.Course_id); comm.Parameters.AddWithValue("@student_id", choo1.Stu_id); comm.Parameters.AddWithValue("@stu_name", choo1.stu_name); comm.Parameters.AddWithValue("@course_name", choo1.Course_name); comm.Parameters.AddWithValue("@student_grade", choo1.Student_grade); comm.Parameters.AddWithValue("@course_year", choo1.course_year); int result = comm.ExecuteNonQuery(); conn.Close(); return(result); }
private void button6_Click(object sender, EventArgs e) { try { int flag = 0; int item = dataGridView1.CurrentRow.Index; string str1 = dataGridView1.Rows[item].Cells[0].Value.ToString(); string str2 = dataGridView1.Rows[item].Cells[1].Value.ToString(); string str3 = dataGridView1.Rows[item].Cells[2].Value.ToString(); choose_course choo1 = new choose_course(); choo1.Course_id = str1; choo1.Stu_id = bb; choo1.stu_name = ss; choo1.Course_name = str2; choo1.Student_grade = "-1"; choo1.course_year = str3; DAL dal = new DAL(); DataSet ds1 = new DataSet(); ds1 = dal.stu_choose_getbystu_id(bb); for (int i = 0; i < ds1.Tables["ct"].Rows.Count; i++) { if (ds1.Tables["ct"].Rows[i][0].ToString() == str2) { MessageBox.Show("此课程已在您需要学习的课程中,请添加其他课程"); flag = 1; break; } } if (flag == 0) { if (dal.stu_choose_course_insert(choo1) > 0) { MessageBox.Show("此课程已成功添加到您要学习的课程中,请进入课程信息查看"); } else { MessageBox.Show("添加课程失败,请重新选中添加"); } } } catch (Exception ee) { MessageBox.Show(ee.Message); } }