xiu.cs

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

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


namespace www
{
	public class MyCodeBehind : Page 
	{ 
		public System.Web.UI.WebControls.TextBox biaoti; 
		public System.Web.UI.WebControls.TextBox neirong;
		public System.Web.UI.WebControls.TextBox zuozhe;
		public HtmlInputButton Button1;
		public DataRow dr;
		public String newsid;

		void Page_Load(Object sender, EventArgs e) 
		{
			if(!IsPostBack) 
			{
				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];
				
				biaoti.Text=dr["biaoti"].ToString();
				neirong.Text=dr["neirong"].ToString();
				zuozhe.Text=dr["zuozhe"].ToString();
	
			}
		}

			public void Button1_Click(object Source, EventArgs e) 
	
			{ 
				newsid = Request.Params["id"];
				OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("new.mdb"));         
				OleDbCommand myCommand = new OleDbCommand("UPDATE news set biaoti='" + biaoti.Text + "', neirong='" + neirong.Text + "',zuozhe='" + zuozhe.Text +"' WHERE id="+newsid,  myConnection); 
				myCommand.Connection.Open();
				myCommand.ExecuteNonQuery();  
				myCommand.Connection.Close(); 
				Response.Redirect("update.aspx") ; 
			}

	}        

		
}