adminpwdchang.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 adminpwdchang : System.Web.UI.Page
{
    SqlCommand cmd, cmd1;
    SqlConnection cn;
    SqlDataReader dr, dr1;
    SqlDataAdapter da, da1;
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
    string strsql, strsql1, strsql2;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            if (Session["adminname"] == null)
            {
                Response.Redirect("index.aspx");
            }
            else
            {
                this.txtadminname.Text = Convert.ToString(Session["adminname"]);
            }
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (this.IsValid)
        {
            cn = sqldata.createcon();
            cn.Open();
            strsql2 = "select * from admin where adminname='" + this.txtadminname.Text.ToString().Trim() + "' and adminpwd='"+this.txtoldpwd .Text .ToString ().Trim ()+"'";
            cmd1 = new SqlCommand(strsql2, cn);
            dr = cmd1.ExecuteReader();
            if (dr.Read())
            {
                Session["adminname"] = dr["adminname"].ToString().Trim();
                Session["adminpwd"] = dr["adminpwd"].ToString();
                dr.Close();
                strsql1 = "update admin set adminname='"+this .txtadminname .Text .ToString().Trim ()+"',adminpwd='" + this.txtnewpwdagina .Text.ToString().Trim() + "' where id="+Session ["id"];
                cmd = new SqlCommand(strsql1, cn);
                cmd.ExecuteNonQuery();

                cn.Close();
                this.Label1.Text = "修改成功";
               

            }
            else
            {
                this.Label1.Text = "旧密码输入错误！";
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.txtoldpwd.Focus();
    }
}