62,268
社区成员
发帖
与我相关
我的任务
分享 <asp:Login ID="Login1" runat="server" onauthenticate="Login1_Authenticate"
style="text-align: center">
</asp:Login>
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string conStr = WebConfigurationManager.ConnectionStrings["Demo"].ConnectionString;
string sqlStr = "SELECT * FROM Admin WHERE AdminName=@Name AND AdminPwd=@Pwd";
using (SqlConnection conn = new SqlConnection(conStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sqlStr;
cmd.Parameters.AddWithValue("@Name", ((Login)sender).UserName.ToString());
cmd.Parameters.AddWithValue("@Pwd", ((Login)sender).Password.ToString());
using (SqlDataReader dr = cmd.ExecuteReader())
{
int num = 0;
while (dr.Read())
{
Session["Id"] = dr[0].ToString();
num++;
}
if (num == 0)
{
e.Authenticated = false;
}
else
{
e.Authenticated = true;
}
}
}
}
}