newsdetail.aspx.cs

asp做的新闻系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
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 news
{
	/// <summary>
	/// Zhuan1 的摘要说明。
	/// </summary>
	public partial class NewsDetail : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.AdRotator Adrotator1;
	
		public DataRow dr;		//视图
		public string newsid;	//新闻编号
		public void Page_Load(Object sender, EventArgs e) 
		{	
			//创建数据库连接，获取新闻信息
			newsid = Request.Params["id"];
			string strDBPath = System.Configuration.ConfigurationSettings.AppSettings["DBPath"];
			string strConn = System.Configuration.ConfigurationSettings.AppSettings["Connection"] +  Server.MapPath(strDBPath);
			OleDbConnection myConnection = new OleDbConnection(strConn);
			OleDbDataAdapter myCommand = new  OleDbDataAdapter("SELECT * FROM News WHERE id="+newsid, myConnection); 
			DataSet ds = new DataSet();
			myCommand.Fill(ds, "News");
			dr = ds.Tables["News"].Rows[0];
			//获取新闻的点击率
			OleDbCommand myCommand2= new OleDbCommand("select click from News where id="+newsid,myConnection);
			myCommand2.Connection.Open();
			OleDbDataReader reader = myCommand2.ExecuteReader();
			reader.Read();
			int i = reader.GetInt32(0);
			i = i + 1;
			reader.Close();
			//更新新闻的点击率
			myCommand2.CommandText = "UPDATE News SET click = "+i.ToString()+" WHERE id= "+newsid;
			myCommand2.ExecuteNonQuery();
			myCommand2.Connection.Close();
			myConnection.Close();
		}
     
		//格式化字符串
		public string FormatString(string str) 
		{ 
			str=str.Replace(" ","&nbsp;&nbsp;"); 
			str=str.Replace("<","&lt;"); 
			str=str.Replace(">","&gt;"); 
			str=str.Replace('\n'.ToString(),"<br>"); 
			return str; 
		} 

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

		}
		#endregion
	}
}