default.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
       
        string strconn = ConfigurationManager.ConnectionStrings["MMSConnectionString"].ConnectionString.ToString();
       //string strconn = "server=.;database=MMS;uid=sa;pwd=5201314";
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        string mysql="select * from Users where UID='"+this.tbx_uid.Text+"'and UPassword='"+this.tbx_upassword.Text+"'";
        SqlCommand cm = new SqlCommand(mysql, cn);
        SqlDataReader dr = cm.ExecuteReader();
        if (dr.Read())
        {
            this.Label1.Text = "";
            Session["uid"] = dr["uid"];
            Session["upower"] = dr["upower"];
            if ((int)Session["upower"] == 1)
            {
                Response.Redirect("userlist.aspx");
            }
            else
            {
                Response.Redirect("loginsuccess.aspx");
            }

        }
        else
        {
            Label1.Text = "对不起,你输入的用户名和密码错误!请重新输入!";
        }
        cn.Close();
    
    }
}