zhuan.cs

这是一个用ASP加SQL做的新闻网站,里面有不少的新闻可以浏览,共享的.

using System; 
using System.Data; 
using System.Data.OleDb;
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.HtmlControls; 


namespace www
{
	public class MyCodeBehind : Page 
	{ 
	
		public DataRow dr;
		public String newsid;
		public void Page_Load(Object sender, EventArgs e) 
		{
			newsid = Request.Params["id"];
			OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("new.mdb"));    
			OleDbDataAdapter myCommand = new  OleDbDataAdapter("SELECT * FROM news WHERE id="+newsid, myConnection); 
			DataSet ds = new DataSet(); 
			myCommand.Fill(ds, "aa"); 
			dr = ds.Tables["aa"].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++;
			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(" ","  "); 
			str=str.Replace("<","&lt;"); 
			str=str.Replace(">","&gt;"); 
			str=str.Replace('\n'.ToString(),"<br>"); 
			return str; 
		} 
	} 
}