admin_link.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_link 的摘要说明。
	/// </summary>
	public class admin_link : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid LbNews_Link;
		protected System.Web.UI.WebControls.TextBox LinkName;
		protected System.Web.UI.WebControls.TextBox LinkPic;
		protected System.Web.UI.WebControls.TextBox LinkTitle;
		protected System.Web.UI.WebControls.Button addSumit;
		protected Conn ds2=new Conn();
		protected  OleDbDataReader rd;
		protected System.Web.UI.WebControls.RequiredFieldValidator required1;
		protected System.Web.UI.WebControls.RequiredFieldValidator required2;
		protected System.Web.UI.WebControls.RequiredFieldValidator required3;
		protected  DataSet ds;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			ds2.CheckCookies(3);

			if(!Page.IsPostBack)
			{
				LbnewsLink();
			}
		}


		private void LbnewsLink()
		{

			try
			{
				ds2.DBopen();

				ds=ds2.CreateDataSet("select * from Lb_Links","Lb_Links");


				if (ds.Tables["Lb_Links"].DefaultView.Count==0)
				{
				
					Response.Write ("还没有友情链接");
				}
				else
				{
					LbNews_Link.DataSource = ds;
					LbNews_Link.DataBind();
				}
			}
			catch(System.Data.OleDb.OleDbException e)
			{
				Response.Write (e.ToString());
			
			}
			finally
			{
			
				ds2.DBclose();

			}


			 

		}

        
		private void LbAddLink()

		{
			string Link_Title=(string)LinkTitle.Text.Trim();
			string Link_Pic=(string)LinkPic.Text.Trim();
			string Link_Name=(string)LinkName.Text.Trim();
			try
			{
				ds2.DBopen();
	
		
				string SqlAddLink="insert into Lb_links(l_title,l_pic,l_url)values('"+Link_Title+"','"+Link_Pic+"','"+Link_Name+"')"; 
   
				int result3=ds2.ExecuteSql(SqlAddLink);

				if(result3>0)
				{
		
		
					ds2.alert("添加成功","admin_link.aspx");
				
				}
				else
				{
			
					ds2.alert("添加失败","admin_link.aspx");

				}
			}
			catch(System.Data.OleDb.OleDbException ex)
			{
				Response.Write (ex.ToString());

			}

			finally
			{
			
				ds2.DBclose();
	
			}
		
		}


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

		}
		#endregion

		private void LbNews_Link_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
	
			LbNews_Link.EditItemIndex=e.Item.ItemIndex;
			LbnewsLink();
		}

		private void LbNews_Link_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			LbNews_Link.EditItemIndex=-1;
			LbnewsLink();
		}

		private void LbNews_Link_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{

			try
			{
				ds2.DBopen();
				
				TextBox linkTitle = (TextBox)e.Item.Cells[1].Controls[0];
				TextBox linkPic = (TextBox)e.Item.Cells[2].Controls[0];
				int uid=ds2.ChangeToInt(LbNews_Link.DataKeys[e.Item.ItemIndex].ToString());
						
				if (linkTitle.Text=="" || linkPic.Text=="")
				{
					Response.Write ("<script>alert('不能输入空内容');history.back();</script>");
			
			   
				}
				else
				{   
	
					int result=ds2.ExecuteSql("UPDATE Lb_Links SET l_title = '"+linkTitle.Text+"',l_pic = '"+linkPic.Text+"' WHERE l_id = "+uid+"");

					if(result>0)
					{
		
		
						ds2.alert("修改成功","admin_link.aspx");
				
					}
					else
					{
			
						ds2.alert("修改失败","admin_link.aspx");

					}
				
				
					Response.Write ("<script>alert('更改成功');location.href('admin_link.aspx');</script>");
					LbNews_Link.EditItemIndex=-1;
					LbnewsLink();
		
				
				}
			}
			catch(System.Data.OleDb.OleDbException ex)
			{
				Response.Write (ex.ToString());

			}

			finally
			{
			
				ds2.DBclose();
	

			}
		
		}

		private void LbNews_Link_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		
			try
			{
				ds2.DBopen();

				int id=ds2.ChangeToInt(LbNews_Link.DataKeys[e.Item.ItemIndex].ToString());


				string SqlDelLink="delete from Lb_Links WHERE l_id = "+id+""; 
              
              
				int	result2=ds2.ExecuteSql(SqlDelLink);

				if(result2>0)
				{
		
		
					ds2.alert("删除成功","admin_link.aspx");
				
				}
				else
				{
			
					ds2.alert("删除失败","admin_link.aspx");

				}
			}
			catch(System.Data.OleDb.OleDbException ex)
			{
				Response.Write (ex.ToString());

			}

			finally
			{
			
				ds2.DBclose();
	

			}

		}

		private void addSumit_Click(object sender, System.EventArgs e)
		{   
			
			if (Page.IsValid) 
			{
				LbAddLink();
			}
			

		}

		private void LbNews_Link_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{

			LbNews_Link.CurrentPageIndex = e.NewPageIndex; 
			
			LbnewsLink();


		}
																									



	

	}
}