default.aspx.cs

一个简单的ASP.NET校友录系统。基于SQL

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;
/// Download from www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)

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

    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        Response.Redirect("Regist.aspx");
    }
    protected void btnlogin_Click(object sender, ImageClickEventArgs e)
    {
        db login = new db();
        string sql = "select * from username where username='" + tbxusername.Text + "' and pass='" + tbxpass.Text + "'";

        SqlDataReader dr = login.Login(sql);
        if (dr.Read())
        {
            Session["username"] = dr["username"].ToString();
            Session["pass"] = dr["pass"].ToString();

            Response.Redirect("home.aspx");
        }
        else
        {
            Response.Write("<script>alert('输入有误,请重新输入')</script>");
            Response.Redirect("Error.htm");
        }
        dr.Close();
    }
    protected void btnadmin_Click(object sender, EventArgs e)
    {
        db login = new db();
        string sql = "select * from admin where username='" + tbxusername.Text+ "' and pass='" + tbxpass.Text + "'";

        SqlDataReader dr = login.Login(sql);
        if (dr.Read())
        {
            Session["username"] = dr["username"].ToString();
            Session["pass"] = dr["pass"].ToString();

            Response.Redirect("admin/admin.aspx");
        }
        else
        {
            Response.Write("<script>alert('输入有误!')</script>");
            //Response.Redirect("Default.aspx");
            return;
        }
        dr.Close();
    }
}