protected void btnSave_ServerClick(object sender, EventArgs e) { string studentid = divStuentID.InnerText; DbContext db = new DbContext(); db.BeginTransaction(); //OracleCommand cmd = new OracleCommand("DELETE FROM sc_courseenrollments WHERE student_id= :v_student_id"); //OracleParameter para = new OracleParameter("v_student_id ", studentid); //cmd.Parameters.Add(para); //db.AddCommand(cmd); foreach (ListItem item in cblCourses.Items) { OracleCommand cmd2 = new OracleCommand("update_courseenrollments_sp"); cmd2.CommandType = CommandType.StoredProcedure; OracleParameter para1 = new OracleParameter("v_student_id", studentid); cmd2.Parameters.Add(para1); OracleParameter para2 = new OracleParameter("v_course_id", item.Value); cmd2.Parameters.Add(para2); OracleParameter para3 = new OracleParameter("v_selected", item.Selected ? 1 : 0); cmd2.Parameters.Add(para3); db.AddCommand(cmd2); } db.Commit(); ListView1.DataBind(); divMessage.Attributes.Remove("class"); divMessage.Attributes.Add("class", "alert alert-success"); divMessage.InnerText = "Courses for the student were saved successfully."; }