chanagepwd.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class chanagepwd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = "更改密码页面";
        //if (!IsPostBack)
        //{
        //    txtName.Text = Session["userid"].ToString();
        //}
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        SqlConnection con = DB.con();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        con.Open();
        cmd.CommandText = "select * from manage where userid='" + txtName.Text + "' and pwd='" + txtYPwd.Text + "'";
        SqlDataReader sqldatareader = cmd.ExecuteReader();
        
        if (sqldatareader.Read() != true)
        {
            Response.Write("<script>alert('愿密码错误');</script>");
        }
        else
        {
            con.Close();
            con.Open();
            cmd.CommandText = "update manage set pwd=@pwd where userid=@userid";
            cmd.Parameters.AddWithValue("@userid", txtName.Text);
            cmd.Parameters.AddWithValue("@pwd",txtSXPwd.Text);
            cmd.ExecuteNonQuery();
            if (cmd.ExecuteNonQuery() == 1)
            {
                Response.Write("<script>alert('修改成功');</script>");
            }
            con.Close();
        }
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        txtName.Text = txtYPwd.Text = txtXPwd.Text = txtSXPwd.Text = string.Empty;
    }
}