user_edit.aspx.cs

该商品销售管理系统是一个基于WEB的适应于小型企业的管理系统！可以实现商品基本信息的查询。添加

using System;
using System.Data;
using System.Configuration;
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;
using LoginCheckClass;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)    //利用session读取当前登陆username自动在页面加载时显示在textbox1中
    {
        LoginCheck a = new LoginCheck();
        a.check();
        //if (!IsPostBack)
        //{
        this.TextBox1.Text = Convert.ToString(Session["username"]);
        //}
    }
    private static readonly string _connectString = System.Configuration.ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;
    protected void Button1_Click(object sender, EventArgs e)    //定义button_1也就是修改按钮得click事件
    {
         try
        {
            using (SqlConnection conn = new SqlConnection(_connectString))  //连接数据库
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    code codeuser_edit = new code();
                    string Finaldata = codeuser_edit.Encrypt(this.TextBox2 .Text);
                    cmd.Parameters.Clear();
                    //根据在textbox2中的密码信息,tb_user表中找到对应得usename,用update命令更新数据库信息
                    cmd.CommandText = "UPDATE tb_User SET userpwd = @userpwd,AddTime=@AddTime WHERE username =@username";
                    cmd.Parameters.Add("@userpwd", SqlDbType.VarChar, 50).Value = Finaldata;
                    cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = this.TextBox1 .Text;
                    cmd.Parameters.Add("@AddTime", SqlDbType.DateTime).Value = DateTime.Now.ToLongTimeString();
                    cmd.ExecuteNonQuery();
                    this.TextBox2.Text = "";   //自动清空textbox2,也就是输入密码得数据框
                    Response.Write("<script>alert('修改密码成功！');</script>");
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('系统错误！');</script>");
        }

  }



    protected void Button2_Click(object sender, EventArgs e)    //定义button_2也就是重置按钮得click事件
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
    }
}