1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using MyOnLineExam.BusinessLogicLayer;
12
13public partial class Web_admin_SingleSelectLists : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!IsPostBack)
18        ...{
19            ImageButton1.Attributes.Add("OnClick", "javascript:return confirm('确实要删除这些试题吗？')");
20            InitDDLData();  //初始化考试科目          
21        }
22    }
23
24    //初始化考试科目
25    protected void InitDDLData()
26    ...{        
27        Course course = new Course();       //创建考试科目对象
28        DataSet ds = course.QueryCourse();  //查询考试科目信息
29        ddlCourse.DataSource = ds;          //指名考试科目列表框数据源
30        ddlCourse.DataTextField = "Name";   //DataTextField显示Name字段值
31        ddlCourse.DataValueField = "ID";    //DataValueField显示ID字段值
32        ddlCourse.DataBind();               //绑定数据
33    }
34    //显示选择科目的单选题
35    protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
36    ...{
37        GridViewBind();//为GridView绑定数据
38    }
39    //GridView控件绑定数据事件
40    protected void GridViewBind()
41    ...{
42        SingleProblem singleproblem = new SingleProblem();  //创建单选题对象
43        DataSet ds = singleproblem.QuerySingleProblem(int.Parse(ddlCourse.SelectedValue));//根据考试科目查询单选题信息
44        GridView1.DataSource = ds.Tables[0].DefaultView;    //为GridView控件指名数据源
45        GridView1.DataBind();                               //绑定数据
46    }
47    //删除试题事件
48    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
49    ...{
50        SingleProblem singleproblem = new SingleProblem();  //创建单选题对象
51        int ID=int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
52        if (singleproblem.DeleteByProc(ID))
53        ...{
54            Response.Write("<script language=javascript>alert('成功删除试题！')</script>");
55        }
56        else
57        ...{
58            Response.Write("<script language=javascript>alert('删除试题失败！')</script>");
59        }
60        GridView1.EditIndex = -1;
61        GridViewBind();//重新绑定数据
62    }
63    //删除多条记录
64    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
65    ...{
66        SingleProblem single = new SingleProblem();//创建SingleProblem对象        
67        foreach (GridViewRow dr in GridView1.Rows)//对GridView中的每一行进行判断
68        ...{
69            if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果选择了进行删除
70            ...{
71                int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
72                single.ID = ID;
73                single.DeleteByProc(ID);                
74            }
75        }
76    }
77}
78