login.aspx.cs

漂亮的留言管理系统

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

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = DB.createCon();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select count(*) from admin where adminName='"+this.txtUserName.Text+"' and adminPwd='"+this.txtPwd.Text+"'";
        cmd.Connection = conn;
        if (Convert.ToInt32(cmd.ExecuteScalar()) > 0)
        {
            Session["admin"] = "admin";
            Response.Write("<script>alert('登陆成功！');location.href='default.aspx';</script>");
        }
        else
        {
            Response.Write("<script>alert('登陆失败，请确认您的用户名和密码！');location.href='login.aspx';</script>");
        }
    }
}