login.aspx.cs

来自「水晶报表详细资料水晶报表详细资料水晶报表详细资料」· CS 代码 · 共 42 行

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;

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

    }
    protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    {

    }
    
    protected void Login1_Authenticate1(object sender, AuthenticateEventArgs e)
    {
        System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("server=ZHY\\ZHY;uid=sa;pwd=;database=aspnetdb");
        con.Open();
        string strSql = "select * from tb_01 where userid='" + Login1.UserName.ToString() + "' and username='" + Login1.Password + "'";
        System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(strSql, con);
        System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader();
        if (dr.Read())
        {
            e.Authenticated = true;//通过验证
        }
        else
        {
            e.Authenticated = false;
        }
        dr.Close();
        con.Close();
      
    }
}