edituserinfo.aspx.cs

完成一个网上书店系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class EditUserInfo : System.Web.UI.Page
{
    Class1 db = new Class1();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["UserName"] == null || Session["UserName"].ToString() == "")
            {
                Response.Redirect("login.aspx");
            }
            Label3.Text = Convert.ToString(Session["UserName"]);
            Label4.Text = Convert.ToString(Session["UserName"]);
            Bind();
        }
    }
    protected void Bind()
    {
        int uid = Convert.ToInt32(Session["UserID"]);
        string sql="select * from Users where UserID=" +uid;
        SqlDataReader dr=db.Reader(sql);
       if (dr.Read())
       {
           TextBox3.Text = dr["EMail"].ToString();
           TextBox4.Text = dr["Address"].ToString();
           TextBox5.Text = dr["TelephoneNumber"].ToString();
          
       }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //修改
        string pass = TextBox2.Text;
        string email = TextBox3.Text;
        string address = TextBox4.Text;
        string tel = TextBox5.Text;
        int uid = Convert.ToInt32(Session["UserID"]);
        string sql = String.Format("update Users set EMail='{0}',Address='{1}',TelephoneNumber='{2}' ,Password='{3}'where UserID={4} ", email, address, tel,pass, uid);
        if (db.ExecSql(sql))
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "MessageBox", "alert('保存成功')", true);
        }
        else
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "MessageBox", "alert('保存失败，请检查！')", true);
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //重置
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
    }
}