tdefault.aspx.cs

在线考试系统： 1、为了保证示例代码正确运行

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Data.SqlClient;

namespace TestOnline
{
	/// <summary>
	/// TDefault 的摘要说明。
	/// </summary>
	public class TDefault : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnlogout;
		protected System.Web.UI.WebControls.Button btnquestion;
		protected System.Web.UI.WebControls.Button btnanalysis;
		protected System.Web.UI.WebControls.DataGrid dgdpaper;
		protected System.Web.UI.WebControls.DataGrid dgdscore;
		protected System.Web.UI.WebControls.Button btnsearch;
		protected System.Web.UI.WebControls.DropDownList dplpapername;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面 
			if (!IsPostBack ) 
			{
				dgdscore.Visible = true;
				dgdpaper.Visible = false;
				Bind_PaperName();
				Bind_Grid();
			}
       
		}
		void Bind_PaperName()
		{
			//创建数据库连接对象
			SqlConnection objconn = new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			objconn.Open();
			String objsql   = "Select PaperName from Papers";
			SqlDataAdapter da = new SqlDataAdapter(objsql, objconn);
			//创建并填充DataSet
			DataSet ds = new DataSet();
			da.Fill(ds, "Papers");
			dplpapername.DataSource = ds;
			dplpapername.DataMember = "Papers";
			dplpapername.DataTextField = "PaperName";
			dplpapername.DataBind();
			objconn.Close();
		}
		void Bind_Grid()
		{
			//创建数据库连接对象
			SqlConnection objconn = new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			SqlCommand objcmd = new SqlCommand("TScore", objconn);
			//设定命令类型
			objcmd.CommandType = CommandType.StoredProcedure;
			//打开数据库连接
			objconn.Open();
			SqlDataReader result = objcmd.ExecuteReader(CommandBehavior.CloseConnection);
			dgdscore.DataSource = result;
			dgdscore.DataBind();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnsearch.Click += new System.EventHandler(this.btnsearch_Click);
			this.btnanalysis.Click += new System.EventHandler(this.btnanalysis_Click);
			this.btnquestion.Click += new System.EventHandler(this.btnquestion_Click);
			this.btnlogout.Click += new System.EventHandler(this.btnlogout_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnanalysis_Click(object sender, System.EventArgs e)
		{
		Response.Redirect("Analysis.aspx");
		}

		private void btnsearch_Click(object sender, System.EventArgs e)
		{
			dgdscore.Visible = false;
			dgdpaper.Visible = true;
			//创建数据库连接对象
			SqlConnection objconn = new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			String papername  = dplpapername.SelectedValue.ToString();
            
			SqlCommand objcmd = new SqlCommand("TScore1", objconn);
			//设定命令类型
			objcmd.CommandType = CommandType.StoredProcedure;
			//打开数据库连接
			objconn.Open();
			SqlParameter paramPaperName = new SqlParameter("@PaperName", SqlDbType.NVarChar, 50);
			paramPaperName.Value = papername;
			objcmd.Parameters.Add(paramPaperName);
			SqlDataReader result = objcmd.ExecuteReader(CommandBehavior.CloseConnection);
			dgdpaper.DataSource = result;
			dgdpaper.DataBind();
		}

		private void btnlogout_Click(object sender, System.EventArgs e)
		{
			Session["username"] = "";
			Response.Redirect("login.aspx");
		}

		private void btnquestion_Click(object sender, System.EventArgs e)
		{
			 Response.Redirect("AddPaper.aspx");
		}
	}
}