updatecate.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.Data.SqlClient;

public partial class Web_UpdateCate : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();

    protected void Page_Load(object sender, EventArgs e)
    {
        //this.btnClose.Attributes.Add("onclick", "history.back()");
        if(!IsPostBack)
        {
            SqlConnection conn = new SqlConnection
                (System.Configuration.ConfigurationManager.ConnectionStrings["db_KnowledgeConnectionString"].ToString());
            conn.Open();

            //取得ID
            string strID = Request.QueryString["Category_id"];

            //取得相关数据
            string strsql = "SELECT Category_name,Category_parent_id FROM tb_Category WHERE Category_id='" + strID + "'";
            SqlDataAdapter sda = new SqlDataAdapter(strsql, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "tb_Category");
            DataRowView rowview = ds.Tables["tb_Category"].DefaultView[0];

            string strName = rowview["Category_name"].ToString();
            string strParentID = rowview["Category_parent_id"].ToString();
            
            //为类别名称文本框赋值
            this.txbCatename.Text = strName;

            //为父类别下拉列表赋值
            SqlDataAdapter sda1 = new SqlDataAdapter("SELECT Category_name,Category_id  FROM tb_Category" , conn);
            DataSet ds1 = new DataSet();
            sda1.Fill(ds1,"tb_Category"); 

            //DropdownList通过DataSet赋值
            this.ddlCateParent.DataSource = ds1;
            this.ddlCateParent.DataValueField = "Category_id";
            this.ddlCateParent.DataTextField = "Category_name";
            this.ddlCateParent.DataBind();
            this.ddlCateParent.Items.Insert(0, new ListItem("<--请选择父类别-->", ""));
            
            this.ddlCateParent.SelectedValue = strParentID;
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
      
       SqlConnection sqlCon = new SqlConnection
           (System.Configuration.ConfigurationManager.ConnectionStrings["db_KnowledgeConnectionString"].ToString());

            bc.ExecSQL("UPDATE tb_Category SET Category_name = '" + txbCatename.Text + "',Category_parent_id ='" + ddlCateParent.SelectedValue + "' WHERE Category_id  ='" + Request.QueryString["Category_id"] + "'");
            Response.Write(bc.MessageBox("数据修改成功！"));
            Response.Write("<script>window.close()</script>");
            Page.Response.Redirect("~/Web/ListCate.aspx");

      }
     
    protected void btnClose_Click(object sender, EventArgs e)
    {
       //Response.Write("<script language:javascript>javascript:window.close();</script>");
       //Response.Write("<script language:javascript>javascript:history.back();</script>");
       Page.Response.Redirect("~/Web/ListCate.aspx");


    }
}