UpdateUserInfo.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;

public partial class UpdateUserInfo : System.Web.UI.Page
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["MemberName"] == null)
            {
                Response.Write("<script language='javascript'>alert('没有登录，不能操作！');location='javascript:history.go(-1)';</script>");
            }
            else
            {
                GetUserInfo();
            }
        }
       
    }
    private void GetUserInfo()
    {
        string sql = "select * from TB_User where UserName ='" + Session["MemberName"]+"'";
        DataTable dt = DBHelper.GetDataSet(sql).Tables[0];

        this.TextBox1.Text = dt.Rows[0]["UserName"].ToString();
        this.TextBox2.Text = dt.Rows[0]["PassWord"].ToString();
        this.TextBox3.Text = dt.Rows[0]["PassWord"].ToString();

        this.TextBox7.Text = dt.Rows[0]["Email"].ToString();
        this.TextBox8.Text = dt.Rows[0]["Tel"].ToString();
      
    }
 
    protected void Button1_Click(object sender, EventArgs e)
    {

        string SQL = "update TB_User set UserName='" + this.TextBox1.Text + "',PassWord='" + this.TextBox2.Text + "',Email='" + this.TextBox7.Text + "',Tel='" + this.TextBox8.Text + "' where UserName ='" + Session["MemberName"] + "'";
      
        bool iRet = DBHelper.ExecSql(SQL);
        if (iRet)
        {
            GetUserInfo();
            Response.Write("<script language='javascript'>alert('修改成功！');location='javascript:history.go(-1)';</script>");
        }
        else
        {
            Response.Write("<script language='javascript'>alert('修改失败！');location='javascript:history.go(-1)';</script>");
        }
    }
}