protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { Datacon db = new Datacon(); string insertpaper = "insert into TaoTi(c_id,PaperName,PaperState,JoinTime,AnswerTime,Score,teacher_id) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "','" + DropDownList2.SelectedValue + "','" + DateTime.Now.ToString() + "','" + DropDownList1.SelectedValue + "', '" + Label21.Text + "','" + Session["ID"] + "')"; int afterID = db.GetIDInsert(insertpaper);//保存试卷,并返回自动生成的试卷编号 if (afterID > 0) { foreach (GridViewRow dr in GridView1.Rows)//保存试卷单选题信息 { string single = "insert into TaoTiDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + int.Parse(((Label)dr.FindControl("Label3")).Text) + "," + int.Parse(SingleFen.Text) + ")"; db.Insert(single); } foreach (GridViewRow dr in GridView2.Rows)//保存试卷多选题信息 { string multi = "insert into TaoTiDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + int.Parse(((Label)dr.FindControl("Label6")).Text) + "," + int.Parse(MultiFen.Text) + ")"; db.Insert(multi); } foreach (GridViewRow dr in GridView3.Rows)//保存试卷判断题信息 { string judge = "insert into TaoTiDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + int.Parse(((Label)dr.FindControl("Label7")).Text) + "," + int.Parse(JudgeFen.Text) + ")"; db.Insert(judge); } } Response.Write("<script>alert('添加成功!')</script>"); Response.Write("<script>window.location.href='AddTaoTi.aspx'</script>"); }