Admin/QuestionManage.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Data.Linq;

public partial class Admin_QuestionManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		if(!Page.IsPostBack)
		{
			BindPageData();
			if(ddlSubject.Items.Count > 0)
			{   ///设置第一个为默认选项，并显示该考试科目的考题
				ddlSubject.SelectedIndex = 0;
				BindPageData(Int32.Parse(ddlSubject.SelectedValue));
			}
		}
    }

	private void BindPageData()
	{   ///创建ExamineDB数据库的数据上下文
		ExamineDBDataContext db = new ExamineDBDataContext(OnlineExamineSystem.ExamineDBConnectionString);
		///查询考试科目
		var query = from s in db.Subject					
					select s;
		///绑定控件数据，并显示考试科目
		ddlSubject.DataSource = query;
		ddlSubject.DataTextField = "Name";
		ddlSubject.DataValueField = "ID";
		ddlSubject.DataBind();
	}

	private void BindPageData(int subjectID)
	{   ///创建ExamineDB数据库的数据上下文
		ExamineDBDataContext db = new ExamineDBDataContext(OnlineExamineSystem.ExamineDBConnectionString);
		///查询考题
		var query = from q in db.Question
					where q.SubjectID == subjectID
					select q;
		///绑定控件数据，并显示考题
		gvQuestion.DataSource = query;
		gvQuestion.DataBind();
	}
	protected void ddlSubject_SelectedIndexChanged(object sender,EventArgs e)
	{
		if(ddlSubject.SelectedIndex > -1)
		{   ///显示考题
			BindPageData(Int32.Parse(ddlSubject.SelectedValue));
		}