scoreinfoview.aspx.cs

该系统实现在线考试功能

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

namespace TestOnline
{
	/// <summary>
	/// stuInfoView 的摘要说明。
	/// </summary>
	public class score : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lbl_adminId;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.HyperLink HyperLink5;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (Session["adminId"] == null)
			{
				Response.Redirect("login.aspx");
			}
			else
				lbl_adminId.Text = Convert.ToString(Session["adminId"]);
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{
				SetBind();
			}
		}
		protected void SetBind()
		{
			string strSqlconn = "server = (local); database = TestOnline; uid = sa ; pwd = ok";
			string strsql = "select * from score";
			SqlConnection conn = new SqlConnection(strSqlconn);

			try
			{
				conn.Open();
				SqlDataAdapter adp = new SqlDataAdapter(strsql,conn);
				DataSet ds = new DataSet();
				adp.Fill(ds);

				DataGrid1.DataSource = ds;
				DataGrid1.DataBind();


			}
			finally
			{
				conn.Close();
			}
		}
		//		{
		//			SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
		//			SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
		//			DataSet ds=new DataSet();
		//			da.Fill(ds,"tb1");
		//			this.DataGrid1.DataSource=ds.Tables["tb1"];
		//			this.DataGrid1.DataBind();
		//		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
        
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			string strSqlconn = "server = (local); database = TestOnline; uid = sa ; pwd = ok";
			SqlConnection conn = new SqlConnection(strSqlconn);
			SqlCommand comm=new SqlCommand("insert into score (stuID,stuName,score,XZ_score,TK_score,PD_score) values (@stuID,@stuName,@score,@XZ_score,@TK_score,@PD_score)",conn);
			SqlParameter parm1=new SqlParameter("@stuID",SqlDbType.VarChar,15);
			parm1.Value=this.TextBox1.Text;
			SqlParameter parm2=new SqlParameter("stuName",SqlDbType.VarChar,10);
			parm2.Value=this.TextBox2.Text;
			SqlParameter parm3=new SqlParameter("@score",SqlDbType.Int);
			parm3.Value=this.TextBox3.Text;
			SqlParameter parm4=new SqlParameter("@XZ_score",SqlDbType.Int);
			parm4.Value=this.TextBox4.Text;
			SqlParameter parm5=new SqlParameter("@TK_score",SqlDbType.Int);
			parm5.Value=this.TextBox5.Text;
			SqlParameter parm6=new SqlParameter("@PD_score",SqlDbType.Int);
			parm6.Value=this.TextBox6.Text;
			comm.Parameters.Add(parm1);
			comm.Parameters.Add(parm2);
			comm.Parameters.Add(parm3);
			comm.Parameters.Add(parm4);
			comm.Parameters.Add(parm5);
			comm.Parameters.Add(parm6);
			conn.Open();
			comm.ExecuteNonQuery();
			conn.Close();
			SetBind();
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="del")
			{
				string strSqlconn = "server = (local); database = TestOnline; uid = sa ; pwd = ok";
				SqlConnection conn = new SqlConnection(strSqlconn);
				SqlCommand comm=new SqlCommand("delete from score where ID=@id",conn);
				SqlParameter parm1=new SqlParameter("@id",SqlDbType.Int);
				parm1.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
				comm.Parameters.Add(parm1);
				conn.Open();
				comm.ExecuteNonQuery();
				conn.Close();
				SetBind();
			}
		}

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
			SetBind();
		}

		protected void edit(object sender,DataGridCommandEventArgs e)
		{
			this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
			SetBind();
		}

		protected void cancel(object sender,DataGridCommandEventArgs e)
		{
			this.DataGrid1.EditItemIndex=-1;
			SetBind();
		}

		protected void update(object sender,DataGridCommandEventArgs e)
		{
			string strSqlconn = "server = (local); database = TestOnline; uid = sa ; pwd = ok";
			SqlConnection conn = new SqlConnection(strSqlconn);
			SqlCommand comm=new SqlCommand("update score set stuID=@stuID,stuName=@stuName,score=@score,XZ_score=@XZ_score,TK_score=@TK_score,PD_score=@PD_score where ID=@id",conn);
			SqlParameter parm1=new SqlParameter("@stuID",SqlDbType.NVarChar,100);
			parm1.Value=((TextBox)e.Item.FindControl("ID")).Text;
			SqlParameter parm2=new SqlParameter("@stuName",SqlDbType.NVarChar,50);
			parm2.Value=((TextBox)e.Item.FindControl("name")).Text;
			SqlParameter parm3=new SqlParameter("@score",SqlDbType.NVarChar,50);
			parm3.Value=((TextBox)e.Item.FindControl("score")).Text;
			SqlParameter parm4=new SqlParameter("@XZ_score",SqlDbType.NVarChar,50);
			parm4.Value=((TextBox)e.Item.FindControl("XZ_score")).Text;
			SqlParameter parm5=new SqlParameter("@TK_score",SqlDbType.NVarChar,50);
			parm5.Value=((TextBox)e.Item.FindControl("TK_score")).Text;
			SqlParameter parm6=new SqlParameter("@PD_score",SqlDbType.Int);
			parm6.Value=((TextBox)e.Item.FindControl("PD_score")).Text;
			SqlParameter parm7=new SqlParameter("@id",SqlDbType.Int);
			parm7.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
			comm.Parameters.Add(parm1);
			comm.Parameters.Add(parm2);
			comm.Parameters.Add(parm3);
			comm.Parameters.Add(parm4);
			comm.Parameters.Add(parm5);
			comm.Parameters.Add(parm6);
			comm.Parameters.Add(parm7);
			conn.Open();
			comm.ExecuteNonQuery();
			conn.Close();
			this.DataGrid1.EditItemIndex=-1;
			SetBind();
		}

		private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			foreach(DataGridItem di in this.DataGrid1.Items)
			{
				if(di.ItemType==ListItemType.Item||di.ItemType==ListItemType.AlternatingItem)
				{
					((LinkButton)di.Cells[7].Controls[0]).Attributes.Add("onclick","return confirm('delete?');");
				}
			}
		}
	}
}