?? admin_singleselectlists.aspx.cs
字號:
?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyOnLineExam.BusinessLogicLayer;
public partial class Web_admin_SingleSelectLists : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ImageButton1.Attributes.Add("OnClick", "javascript:return confirm('確實要刪除這些試題嗎?')");
InitDDLData(); //初始化考試科目
}
}
//初始化考試科目
protected void InitDDLData()
{
Course course = new Course(); //創建考試科目對象
DataSet ds = course.QueryCourse(); //查詢考試科目信息
ddlCourse.DataSource = ds; //指名考試科目列表框數據源
ddlCourse.DataTextField = "Name"; //DataTextField顯示Name字段值
ddlCourse.DataValueField = "ID"; //DataValueField顯示ID字段值
ddlCourse.DataBind(); //綁定數據
}
//顯示選擇科目的單選題
protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewBind();//為GridView綁定數據
}
//GridView控件綁定數據事件
protected void GridViewBind()
{
SingleProblem singleproblem = new SingleProblem(); //創建單選題對象
DataSet ds = singleproblem.QuerySingleProblem(int.Parse(ddlCourse.SelectedValue));//根據考試科目查詢單選題信息
GridView1.DataSource = ds.Tables[0].DefaultView; //為GridView控件指名數據源
GridView1.DataBind(); //綁定數據
}
//刪除試題事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SingleProblem singleproblem = new SingleProblem(); //創建單選題對象
int ID=int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要刪除記錄的主鍵值
if (singleproblem.DeleteByProc(ID))
{
Response.Write("<script language=javascript>alert('成功刪除試題!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('刪除試題失敗!')</script>");
}
GridView1.EditIndex = -1;
GridViewBind();//重新綁定數據
}
//刪除多條記錄
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SingleProblem single = new SingleProblem();//創建SingleProblem對象
foreach (GridViewRow dr in GridView1.Rows)//對GridView中的每一行進行判斷
{
if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果選擇了進行刪除
{
int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
single.ID = ID;
single.DeleteByProc(ID);
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -