update3.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 update3 : System.Web.UI.Page
{
    private string ctcontent = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        ctcontent = Request.QueryString["ctcodeID"];
        if (!Page.IsPostBack)
        {
            BindData(ctcontent);
        }
    }
    private void BindData(String ctcontent)
    {
        edit cla = new edit();
        string cmdText = "select * from users where username=" + "'" + ctcontent + "'";
        SqlDataReader dr = cla.GetSingleCTCode(cmdText);
        if (dr.Read())
        {
            username.Text = dr["username"].ToString();
            pass.Text = dr["password"].ToString();
            jibie.Text = dr["jibie"].ToString();
        }
        if (jibie.Text.Equals("管理者"))
        {
            jibie.Enabled = true;
        }
        else
         {
             jibie.Enabled = false;
         }
        dr.Close();

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string temp = Request.QueryString["ctcodeID"];
        edit cla = new edit();
        String cmdtext = "update users set username='" +username.Text.Trim() +
            "',password='" + pass.Text.Trim() + "' where username=" + "'" + temp + "'";
        cla.execute(cmdtext);
        Response.Write("<script>alert('" + "更新数据成功，请妥善保管好数据！" + "');</script>");
        Response.Redirect("relmanage.aspx");
    }
}