updatenews.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>
	/// updateNews 的摘要说明。
	/// </summary>
	public class updateNews : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.HtmlControls.HtmlTable addnewsTable;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		DataSet ds=new DataSet();
		public static string strid,strid1;
		ECClass.News en=new ECClass.News();
		bool bo;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Page.IsPostBack==false)
			{
				//i=0;
				show();
				this.addnewsTable.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.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)
		{
			ECClass.T_AppManger ea=new ECClass.T_AppManger();
			ds=ea.showalldata("News");
			DataGrid1.DataSource=ds.Tables[0];
			this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
			DataGrid1.DataBind();
		}
		private void DataGrid1_DeleteCommand(object sender,System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			strid=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
			bo=en.db_delete(strid);
			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.addnewsTable.Visible=true;
			this.DataGrid1.Visible=false;
			strid1=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
			ds=en.db_select(strid1);
			this.TextBox1.Text=ds.Tables[0].Rows[0]["N_title"].ToString();
			this.TextBox2.Text=ds.Tables[0].Rows[0]["N_infor"].ToString();
		}
		public void show()
		{
			ECClass.T_AppManger ea=new ECClass.T_AppManger();
			ds=ea.showalldata("News");
			DataGrid1.DataSource=ds.Tables[0];
			DataGrid1.DataBind();
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			//bo=en.db_update(Session["m_name"],this.TextBox1.Text,this.TextBox2.Text);
			bo=en.db_update("zwm",this.TextBox1.Text,this.TextBox2.Text,strid1);
			if(bo==true)
			{
				Response.Write("<script>alert('修改成功!')</script>"); 
				show();
				this.DataGrid1.Visible=true;
				this.addnewsTable.Visible=false;
			}
			else
			{
				Response.Write("<script>alert('修改不成功!')</script>"); 
			}
		}
	}
}