user_edit.aspx.cs

B2B网上商城

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 User_Edit : System.Web.UI.Page
{
    public DBConnection conn = new DBConnection();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["username"] == null)
            {
                Response.Write("<script language='JavaScript'>");
                Response.Write("alert('请先登录！')");
                Response.Write("</script>");
                Response.End();
                return;
            }
            string username = Session["username"].ToString();
            string sql = "SELECT * FROM Users where UserName='" + username + "'";
            SqlDataReader dr = conn.ExecuteReader(sql);

            if (dr.Read())
            {
                TextBox1.Text = dr["UserName"].ToString();
                TextBox7.Text = dr["TrueName"].ToString();
                TextBox2.Text = dr["PassWord"].ToString();
                TextBox3.Text = dr["PassWord"].ToString();
                Radio.SelectedValue = dr["Sex"].ToString();
                TextBox8.Text = dr["QQ"].ToString();
                TextBox9.Text = dr["IDCard"].ToString();
                TextBox10.Text = dr["HomePage"].ToString();
                TextBox11.Text = dr["Phone"].ToString();
                TextBox12.Text = dr["Address"].ToString();
                TextBox15.Text = dr["PostalCode"].ToString();
                TextBox4.Text = dr["Email"].ToString();
                TextBox5.Text = dr["Email"].ToString();
                TextBox13.Text = dr["Question"].ToString();
                TextBox14.Text = dr["Answer"].ToString();
                dr.Close();
            }
            else
            {
                Response.Write("<script language='JavaScript'>");
                Response.Write("alert('没有该用户！')");
                Response.Write("</script>");
                return;
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string username, TrueName, password, sex, qq, idcard, homepage, phone, address, postalcode, email, question, answer;
        username = TextBox1.Text;
        TrueName = TextBox7.Text;
        password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox2.Text, "MD5");
        sex = Radio.SelectedItem.Value;
        qq = TextBox8.Text;
        idcard = TextBox9.Text;
        homepage = TextBox10.Text;
        phone = TextBox11.Text;
        address = TextBox12.Text;
        postalcode = TextBox15.Text;
        email = TextBox4.Text;
        question = TextBox13.Text;
        answer = TextBox14.Text;
        //执行sql更新命令
        string sql2 = "update Users set TrueName='" + TrueName + "',PassWord='" + password + "',Sex='" + sex + "',QQ='" + qq + "',IDCard='" + idcard + "',HomePage='" + homepage + "',Phone='" + phone + "',Address='" + address + "',PostalCode='" + postalcode + "',Email='" + email + "',Question='" + question + "',Answer='" + answer + "' where UserName='" + username + "'";
        conn.Updata(sql2);

        Response.Write("<script language='JavaScript'>");
        Response.Write("alert('修改成功！')");
        Response.Write("</script>");
    }
}