updatesubject.aspx.cs

本程序只要配置好IIS就可以直接使用,是一个在线网上考试系统

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;

namespace exam
{
	/// <summary>
	/// updateSubject 的摘要说明。
	/// </summary>
	public class updateSubject : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		DataSet ds=new DataSet();
		public static int i;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		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.TextBox TextBox7;
		protected System.Web.UI.HtmlControls.HtmlTable updateSubjectTable;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox Texttimu;
		protected System.Web.UI.HtmlControls.HtmlTable caxunTable;
		bool bo;
		ECClass.Subject es=new ECClass.Subject();
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Page.IsPostBack==false)
			{
				i=0;
				show();
				this.updateSubjectTable.Visible=false;
			}
		}

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

		}
		#endregion

		private void DataGrid1_PageIndexChanged(object sender,System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			if(i==0)
			{
				ECClass.T_AppManger et=new ECClass.T_AppManger();
				ds=et.showalldata("Subject");
				DataGrid1.DataSource=ds.Tables[0];
				this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
				DataGrid1.DataBind();
			}
			else
			{
				DBClass.DataClass db=new DBClass.DataClass();
				string strsql="select * from Subject where S_question like'%"+ this.Texttimu.Text +"%'";
				ds=db.SelectData(strsql);
				DataGrid1.DataSource=ds.Tables[0].DefaultView;
				this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
				DataGrid1.DataBind();
			}
		}

		private void DataGrid1_DeleteCommand(object sender,System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			bo=es.db_delete(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
			if(bo==true)
			{
				show();
				Response.Write("<script>alert('删除成功!')</script>"); 
			}
			else
			{
				Response.Write("<script>alert('删除不成功!')</script>"); 
			}
		}

		private void DataGrid1_EditCommand(object sender,System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.updateSubjectTable.Visible=true;
			this.DataGrid1.Visible=false;
			this.caxunTable.Visible=false;
			this.TextBox1.Text=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
			ds=es.db_select(this.TextBox1.Text);
			this.TextBox2.Text=ds.Tables[0].Rows[0]["S_question"].ToString();
			this.TextBox3.Text=ds.Tables[0].Rows[0]["S_text1"].ToString();
			this.TextBox4.Text=ds.Tables[0].Rows[0]["S_text2"].ToString();
			this.TextBox5.Text=ds.Tables[0].Rows[0]["S_text3"].ToString();
			this.TextBox6.Text=ds.Tables[0].Rows[0]["S_text4"].ToString();
			this.TextBox7.Text=ds.Tables[0].Rows[0]["S_answer"].ToString();
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			this.DataGrid1.CurrentPageIndex=0;
			i=i+1;
			DBClass.DataClass db=new DBClass.DataClass();
			string strsql="select * from Subject where S_question like'%"+ this.Texttimu.Text +"%'";
			ds=db.SelectData(strsql);
			DataGrid1.DataSource=ds.Tables[0].DefaultView;
			DataGrid1.DataBind();
		}
		
		public void show()
		{
			ECClass.T_AppManger et=new ECClass.T_AppManger();
			ds=et.showalldata("Subject");
			DataGrid1.DataSource=ds.Tables[0];
			DataGrid1.DataBind();
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			bo=es.db_update(this.TextBox2.Text.Trim(),this.TextBox3.Text.Trim(),this.TextBox4.Text.Trim(),this.TextBox5.Text.Trim(),this.TextBox6.Text.Trim(),this.TextBox7.Text.Trim(),this.TextBox1.Text.Trim());
			if(bo==true)
			{
				Response.Write("<script>alert('修改成功!')</script>"); 
				show();
				this.DataGrid1.Visible=true;
				this.updateSubjectTable.Visible=false;
			}
			else
			{
				Response.Write("<script>alert('修改不成功!')</script>"); 
			}
		}

	}
}