userdetail.aspx.cs

这是一个会员管理系统,有管理员与会员的两种权限,基于VS2005和SQL2000上进行的开发,适合初学者.

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 userdetail : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //string uidquery=Request.QueryString["uid"];

        string strconn = ConfigurationManager.ConnectionStrings["MMSConnectionString"].ConnectionString.ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        string mysql = "select * from Users,City where Users.UCityID=City.CID and Users.UID=@UID";
        SqlCommand sc = new SqlCommand(mysql, cn);
        sc.Parameters.Add("@UID", SqlDbType.VarChar);
        sc.Parameters["@UID"].Value = Request.QueryString["uid"];
        SqlDataReader dr = sc.ExecuteReader();
        if (dr.Read())
        {
            this.Label1.Text = dr["UID"].ToString();
            this.Label2.Text = dr["ID"].ToString();
            this.Label3.Text = dr["UID"].ToString();
            if (dr["USex"].ToString() == "1")
            {
                this.Label4.Text = "男";
            }
            else
            {
                this.Label4.Text = "女";

            }
            if (dr["UPower"].ToString() == "1") this.Label5.Text = "管理员";
            else this.Label5.Text = "普通会员";
            this.Label6.Text = dr["CName"].ToString();
            this.Label7.Text = dr["CCountryNm"].ToString();
            this.Label8.Text = dr["Email"].ToString();
            cn.Close();
        }

        else
        {
          
            Response.Write("该用户不存在，请返回!");
            Response.End();
        }
    }
}