admin_setup.aspx.cs

如果遇到MD5加密文件(一般都是这个)

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.Data.OleDb;

namespace Lb_news
{
	/// <summary>
	/// admin_setup 的摘要说明。
	/// </summary>
	public class admin_setup : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox LbNew_Title;
		protected System.Web.UI.WebControls.TextBox LbNew_Url;
		protected System.Web.UI.WebControls.TextBox LbNew_Logo;
		protected System.Web.UI.WebControls.TextBox LbNew_Banner;
		protected System.Web.UI.WebControls.TextBox LbNew_Copyright;
		protected System.Web.UI.WebControls.RequiredFieldValidator required5;
		protected System.Web.UI.WebControls.RegularExpressionValidator regular5;
		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.WebControls.RequiredFieldValidator required1;
		protected System.Web.UI.WebControls.RegularExpressionValidator regular1;
		protected System.Web.UI.WebControls.RequiredFieldValidator required2;
		protected System.Web.UI.WebControls.RegularExpressionValidator regular2;
		protected System.Web.UI.WebControls.RequiredFieldValidator required3;
		protected System.Web.UI.WebControls.RegularExpressionValidator regular3;
		protected System.Web.UI.WebControls.RequiredFieldValidator required4;
		protected System.Web.UI.WebControls.RegularExpressionValidator regular4;
		protected System.Web.UI.WebControls.RequiredFieldValidator CheckBody;
		protected Conn ds1=new Conn();
		protected  OleDbDataReader rd;
		protected System.Web.UI.WebControls.TextBox LbNew_Board;
		protected System.Web.UI.WebControls.TextBox LbNew_Script;
		protected System.Web.UI.WebControls.TextBox LbNews_SciptName;
		protected System.Web.UI.WebControls.RequiredFieldValidator CheckScriptName;
		protected System.Web.UI.WebControls.RequiredFieldValidator CheckScript;
		protected  DataSet ds;


		private void Page_Load(object sender, System.EventArgs e)
		{
			ds1.CheckCookies(3);

			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				LbNew_Default();
			}
		}


		private void LbSetupUpdate()
		{
		
			try
			{
				ds1.DBopen();
				string Title=LbNew_Title.Text.ToString();
				string Url=LbNew_Url.Text.ToString();
				string Logo=LbNew_Logo.Text.ToString();
				string Banner=LbNew_Banner.Text.ToString();
				string Copyright=LbNew_Copyright.Text.ToString().Replace("\r\n","<br>");
				string Board=LbNew_Board.Text.ToString().Replace("\r\n","<br>");;
				string ScriptCode=LbNew_Script.Text.ToString().Replace("\r\n","<br>");;
				string ScriptName=LbNews_SciptName.Text.Trim();
				string sql="update Lb_Setup set S_Title='"+Title+"',S_Url='"+Url+"',S_Logo='"+Logo+"',S_Banner='"+Banner+"',S_Copyright='"+Copyright+"',S_Board='"+Board+"',S_ScriptCode='"+ScriptCode+"',S_ScriptName='"+ScriptName+"'";
			
			
				int result=ds1.ExecuteSql(sql);
	
				if(result>0)
				{
		
					ds1.alert("修改成功","admin_setup.aspx");
					
				
				}
				else
				{
			
							
					ds1.alert("修改成功","admin_setup.aspx");

				}
				

			}
			catch (System.Data.OleDb.OleDbException g)
			{
			
				Response.Write (g.ToString());
			}
			finally
			{
				ds1.DBclose();
			}
		
		
		}


		private void LbNew_Default()
		{
		
			try
			{
				ds1.DBopen();
				 
				rd=ds1.ExecuteOleDbDataReader("select * from Lb_Setup");
              
				if (rd.HasRows)
				{
					rd.Read();
					LbNew_Title.Text=(string)rd["S_Title"];
					LbNew_Url.Text=(string)rd["S_Url"];
					LbNew_Logo.Text=(string)rd["S_Logo"];
					LbNew_Banner.Text=(string)rd["S_Banner"];
					LbNew_Copyright.Text=rd["S_Copyright"].ToString().Replace("<br>","\r\n");
					LbNew_Board.Text=rd["S_Board"].ToString().Replace("<br>","\r\n");
					LbNew_Script.Text=(string)rd["S_ScriptCode"].ToString().Replace("<br>","\r\n");
					LbNews_SciptName.Text=(string)rd["S_ScriptName"];
				}
				else
				{
					Response.Write ("暂时还没有记录");
			
				}
			}
			catch(System.Data.OleDb.OleDbException e)

			{
				Response.Write (e.ToString());
			
			}
			finally
			{
				ds1.DBclose();
			}
		}

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

		}
		#endregion

		private void Submit_Click(object sender, System.EventArgs e)
		{

			if (Page.IsValid) 
			{
				LbSetupUpdate();
			}
			
		}
	}
}