protected void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (IsSafe(Request.QueryString["id"], 2) == false) { Response.Write("非法参数,<a href=BlogIndex.aspx>点此返回</a>"); Response.End(); } string ST_dns = ConfigurationSettings.AppSettings["conStr"]; string ST_sql = "select * from ST_news where ST_n_id=" + Request.QueryString["id"] + ""; //最新推荐文章 string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_id desc"; ST_myConn = new SqlConnection(ST_dns); SqlDataAdapter ST_myCmd = new SqlDataAdapter(ST_sql, ST_myConn); SqlDataAdapter ST_classCmd = new SqlDataAdapter("select ST_c_id,ST_c_name from ST_class", ST_myConn); SqlDataAdapter ST_cmdCmd = new SqlDataAdapter(ST_cmd_sql, ST_myConn); DataSet ST_ds = new DataSet(); ST_myCmd.Fill(ST_ds, "新闻查看"); DataSet ST_classds = new DataSet(); ST_classCmd.Fill(ST_classds, "类别列表"); DataSet ST_cmdds = new DataSet(); ST_cmdCmd.Fill(ST_cmdds, "推荐文章"); NewsShow.DataSource = ST_ds.Tables[0]; NewsShow.DataBind(); ClassList.DataSource = new DataView(ST_classds.Tables[0]); ClassList.DataBind(); CmdList.DataSource = new DataView(ST_cmdds.Tables[0]); CmdList.DataBind(); //调用ST_UpdateHit()方法 ST_UpdateHit(); if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; String[] ST_colorList = ST_test.Split(new char[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFDE94"; ST_tcolor = "#efe3ce"; } Page.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string ST_sql = "select * from ST_news where ST_n_id=" + Request.QueryString["id"] + ""; conn.Open(); SqlDataAdapter da = new SqlDataAdapter(ST_sql, conn); DataSet ds = new DataSet(); da.Fill(ds); NewsShow.DataSource = ds.Tables[0]; NewsShow.DataBind(); ST_UpdateHit(); } }
protected void Page_Load(object sender, EventArgs e) { // 在此处放置用户代码以初始化页面 if (IsSafe(Request.QueryString["id"], 2) == false) { Response.Write("错误页面,<a href=BlogIndex.aspx>点此返回</a>"); Response.End(); } string ST_sql = "select * from ST_news where ST_n_id=" + Request.QueryString["id"] + ""; //最新推荐文章 string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_id desc"; string sqlstr = "select ST_c_id,ST_c_name from ST_class"; DataSet ST_ds = myobj.GetDataSet(ST_sql, "ST_news"); DataSet ST_classds = myobj.GetDataSet(sqlstr, "ST_class"); DataSet ST_cmdds = myobj.GetDataSet(ST_cmd_sql, "ST_news"); NewsShow.DataSource = ST_ds.Tables[0]; NewsShow.DataBind(); ClassList.DataSource = new DataView(ST_classds.Tables[0]); ClassList.DataBind(); CmdList.DataSource = new DataView(ST_cmdds.Tables[0]); CmdList.DataBind(); //调用ST_UpdateHit()方法 ST_UpdateHit(); if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; String[] ST_colorList = ST_test.Split(new[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFFFFF"; ST_tcolor = "#cccccc"; } Page.DataBind(); }