Admin/ModifyUser.aspx.cs

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

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

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

public partial class Admin_ModifyWSX : System.Web.UI.Page
{
    SqlHelper data = new SqlHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DropDownList2.DataSource = data.GetDataReader("select * from DepInfo");
            DropDownList2.DataTextField = "Name";
            DropDownList2.DataValueField = "id";
            DropDownList2.DataBind();

            if (Session["UserId"] == null)
            {
                Alert.AlertAndRedirect("对不起您没有登录", "../Login.aspx");
            }
            else
            {
                SqlDataReader dr = data.GetDataReader("select * from Users where  id=" + Request.QueryString["id"].ToString());
                if (dr.Read())
                {
                    Name.Text = dr["Name"].ToString();
                    TName.Text = dr["TName"].ToString();
                    Emal.Text = dr["Emal"].ToString();
                    ZhiWei.Text = dr["ZhiWei"].ToString();
                    Tel.Text = dr["Tel"].ToString();
                    pic.Text = dr["Photo"].ToString();
                    Image2.ImageUrl = "../Photo/" + dr["Photo"].ToString();
                    Address.Text = dr["Address"].ToString();
                    Sex.Items.FindByValue(dr["Sex"].ToString()).Selected = true;//选项Text  

                    DropDownList2.Items.FindByValue(dr["DepId"].ToString()).Selected = true;//选项Text  
                    DropDownList2.Items.FindByText(dr["DepName"].ToString()).Selected = true;//选项Text  

                    DropDownList1.Items.FindByValue(dr["Roule"].ToString()).Selected = true;//选项Text  
                }
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        string sql = "update Users set Name='" + Name.Text + "',TName='" + TName.Text + "',Emal='" + Emal.Text + "',ZhiWei='" + ZhiWei.Text + "',Tel='" + Tel.Text + "',Photo='" + pic.Text + "', Address='" + Address.Text + "',Sex='" + Sex.SelectedValue + "', DepId='" + DropDownList2.SelectedValue + "',DepName='" + DropDownList2.SelectedItem.Text + "',Roule='"+DropDownList1.SelectedValue+"'  where id=" + Request.QueryString["id"].ToString();
        data.RunSql(sql);

        Alert.AlertAndRedirect("修改信息成功", "UserList.aspx");

    }