BackDesk/UpdateNews.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Linq;
using System.Data.SqlClient;

public partial  class UpdateNews : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataSet ds = da.datesetExecute("select * from tb_News where id='" + Request["id"] + "'", "tbNews");
            DataRow[] rows = ds.Tables["tbNews"].Select();
            foreach (DataRow dr in rows)
            {
                this.txtNewsTitle.Text = dr["title"].ToString();
                this.txtNewsContent.Text = dr["content"].ToString();
                this.labTitle.Text = dr["Categories"].ToString();
                this.dlstNewsType.SelectedValue = "" + dr["type"];
               
            }
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        string sqlstring = " UPDATE tb_News SET Title = '" + this.txtNewsTitle.Text + "', Content = '" + this.txtNewsContent.Text + "', Categories = '" + this.labTitle.Text.Trim() + "', Type = '" + this.dlstNewsType.SelectedValue.ToString() + "' WHERE ID = '" + Request.QueryString["id"] + "'";
        SqlDataReader sdr = da.ExecuteRead(sqlstring);
        lblMessage.Text = "修改成功！";

    }
    protected void btnReset_Click(object sender, EventArgs e)
    {
        this.txtNewsContent.Text = "";
        this.txtNewsTitle.Text = "";
        Response.Redirect("~/Admin/NewsList.aspx");
    }
}