Login.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

public partial class Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strUserName, strPWD;//用户名，密码
        strUserName = this.UserName.Value;
        strPWD = this.Password.Value;
        string strsql;
        SqlDataReader myreader;

        strsql = "select ID,uname,pwd from family where uname='" + strUserName + "'";
        clsDB dbo = new clsDB();
        myreader = dbo.GetResultASDataReader(strsql);
        if (myreader.Read())
        {
            //存在用户
            string strUserPwd = myreader["pwd"].ToString();
            if (strPWD == strUserPwd)
            {//密码正确  
                Session["user"] = this.UserName.Value;
                Session["ID"] = myreader["ID"].ToString();
                Session["pass"] = strUserPwd;
                Response.Redirect("default.aspx");
                myreader.Close();
                myreader.Dispose();
                dbo.killme();
            }
            else
            {
                myreader.Close();
                myreader.Dispose();
                dbo.killme();
                Response.Write("<script>javascript:alert('密码错误');</script>");
            }
        }
        else
        {
            //用户不存在
            myreader.Close();
            myreader.Dispose();
            dbo.killme();
            Response.Write("<script>javascript:alert('用户不存在');</script>");
        }
    }
}