ChangePwd.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace MyPetShop
{
    public partial class ChangePwd : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["login"] != null)
                txtName.Text = Session["login"].ToString();
            else
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('请先登录！');</script>");
                //Response.Write("<script>alert('请先登录！')</script>");
                Button1.Enabled = false;
            }

            // 下载于www.51aspx.com
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            DB db = new DB();
            SqlConnection con = db.GetCon();//连接数据库
            con.Open();//打开连接
            //SqlConnection con = new SqlConnection();
            //con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\MyPetShop.mdf;Integrated Security=True;User Instance=True";
            //con.Open();
            ////先看是否登录
            ////若登录
            if (Session["status"] != null)
            {
                if (Session["status"].ToString() == "顾客")
                {
                    SqlCommand cmd1 = new SqlCommand("select * from UserInf where UserName='" + txtName.Text.ToString() + "'", con);
                    SqlDataAdapter sda = new SqlDataAdapter(cmd1);
                    DataSet ds = new DataSet();
                    sda.Fill(ds);
                    ///看密码输入是否正确
                    DataRow dr = ds.Tables[0].Rows[0];
                    if (txtPwd.Text == dr["UserPwd"].ToString())
                    {
                        dr["UserPwd"] = txtNewpwd.Text;
                        SqlCommandBuilder scb = new SqlCommandBuilder(sda);
                        sda.Update(ds);
                        Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('修改成功！');</script>");
                        //Response.Write("<script>alert('修改成功！')</script>");
                    }
                    else
                        Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('旧密码输入不正确！');</script>");
                        //Response.Write("<script>alert('旧密码输入不正确！')</script>");
                }

                ///若是是管理员