FLOWER/Admin/User/EditUser.aspx.cs

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

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

namespace FLOWER.Admin.User
{
    public partial class EditUser : System.Web.UI.Page
    {
        SQLHelper sqlhelper = new SQLHelper(); 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                if (Request["action"].ToString() == "edit")
                {
                    DataTable dt = sqlhelper.Query("select * from [User]  where UserId='" + Request["loginname"].ToString() + "'").Tables[0];
                    
                    DataRowView mydrv = dt.DefaultView[0];
                    TextBox1.Text = Convert.ToString(mydrv.Row["LoginName"]); 
                    TextBox1.Enabled = false;
                    TextBox2.Text = Convert.ToString(mydrv.Row["UserName"]);
                    TextBox4.Text = Convert.ToString(mydrv.Row["UserPhone"]);
                    TextBox5.Text = Convert.ToString(mydrv.Row["UserEmail"]);
                    //TextBox6.Text = Convert.ToString(mydrv.Row["UserMoney"]);
                    TextBox7.Text = Convert.ToString(mydrv.Row["UserAddress"]); 
                    TextBox3.Attributes.Add("value", Convert.ToString(mydrv.Row["Password"]));
                    for (int i = 0; i < DropDownList1.Items.Count; i++)
                    {
                        if (DropDownList1.Items[i].Value == Convert.ToString(mydrv.Row["UserSex"])) 
                        {
                            DropDownList1.Items[i].Selected = true;
                        }
                    }
                    
                }
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string constring = SQL.constr;
            SqlConnection str = new SqlConnection(constring);
            str.Open();
            string sqlstr = "update [User] set UserSex='" + DropDownList1.SelectedItem.Text + "',Password='" + TextBox3.Text
           + "',UserName = '" + TextBox2.Text + "',UserAddress='"+TextBox7.Text+"',UserPhone='" + TextBox4.Text + "',UserEmail= '" + TextBox5.Text
           + "' where UserId = '" + Request["loginname"].ToString() + "'";
            sqlhelper.DataCom(sqlstr);
            ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), System.DateTime.Now.Ticks.ToString(), "layer.alert('操作成功！', {icon: 1,kin: 'layer-ext-moon',closeBtn: 0}, function () { location.href = 'UserManage.aspx';})", true);
        }
    }
}