userinfo.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 UserInfo : 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"]);
           
            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())
        {
            Label4.Text = dr["UserID"].ToString();
            Label15.Text = dr["UserName"].ToString();
            Label5.Text = dr["Password"].ToString();
            Label6.Text = dr["EMail"].ToString();
            Label11.Text = dr["TelephoneNumber"].ToString();
            Label12.Text = dr["Address"].ToString();
            Label13.Text = dr["MoneyCount"].ToString();
            if (!Convert.ToBoolean(dr["UserRight"]))
            { 
                Label14.Text = "普通用户";
            }
            else
                Label14.Text = "管理员";

        }
    }
}