Project/Admin/User/EditUser.aspx.cs

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

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

namespace Project.Admin.User
{
    public partial class EditUser : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Request.QueryString["id"] != null)
                {
                    string sql = "select * from t_user where id=" + Request.QueryString["id"];
                    SqlDataReader dr = DbHelperSQL.ExecuteReader(sql);
                    dr.Read();
                    txtUserName.Value = dr["username"].ToString();
                    //txtPwd.Attributes.Add("value", dr["password"].ToString());
                    txtRealName.Value = dr["realname"].ToString();
                }

            }
        }

        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSave_Click(object sender, EventArgs e)
        {
            if (DbHelperSQL.Exists("select 1 from t_user where username='" + this.txtUserName.Value.Trim() + "' and id<>" + Request.QueryString["id"]))
            {
                MessageBox.Show(this, "用户名已经存在！");
                return;
            }
            string sql = "update t_user set UserName='" + this.txtUserName.Value.Trim() + "',RealName='" + txtRealName.Value.Trim() + "' where id=" + Request.QueryString["id"];//Password='" + this.txtPwd.Value.Trim() + "'
            if (DbHelperSQL.ExecuteSql(sql) > 0)
            {
                MessageBox.ShowAndRedirect(this, "保存成功！", "UserManage.aspx");
            }
            else
            {
                MessageBox.Show(this, "保存失败！");
            }
        }
    }
}