嗨，如果用户名和密码有效，如何重定向到另一个页面? [英] hi how to redirect to another page if UserName and Password is valid?

问题描述

在我的表中，只有两列是一个UserName和Password ..
如果用户名和密码正确，我想对此进行验证，然后它将重定向到Welcome.aspx页或无效的登录名和密码..
谁能帮忙.. ???

hi in my table only two columns are there one UserName and Password..
i want to validate this if UserName and Password is correct then it wil redirect to Welcome.aspx page or Invalid login and password..
can any one help ..???

推荐答案

使用表单身份验证，并在其中提供默认页面为Welcome.aspx.在Asp.net中搜索Google表单身份验证，您会发现很多文章.

Use form authentication and give there default page as Welcome.aspx. Search on Google Form Authentication in Asp.net you will found many articles.

C#

protected void ValidateUserInfo(string user, string pass)
{
  
    SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");
    string sql = "SELECT * FROM TableName WHERE UserID = @username AND Password = @password";
    SqlCommand cmd = new SqlCommand(sql,connection);
    cmd.Parameters.AddWithValue("@username", user);
    cmd.Parameters.AddWithValue("@password", pass);
    connection.Open();
 
    DataTable dt = new DataTable();
    SqlDataAdapter ad = new SqlDataAdapter(cmd);
    ad.Fill(dt);
    if (dt.Rows.Count > 0) { //check if the query returns any data
        //Valid Username and Password
        Response.Redirect("Default.aspx");
    }
    else
    {
        Response.Write("INVALID Username and Password, Try Again!");
    }
    connection.Close();   
}
protected void Button1_Click(object sender, EventArgs e)
{
  ValidateUserInfo(TextUserName.Text.Trim(), TextPassword.Text.Trim());
}

VB.NET

VB.NET

Protected Sub ValidateUserInfo(ByVal user As String, ByVal pass As String)
   
    Dim connection As New SqlConnection("YOUR CONNECTION STRING HERE")
    Dim sql As String = "SELECT * FROM TableName WHERE UserID = @username AND Password = @password"
    Dim cmd As New SqlCommand(sql, connection)
    cmd.Parameters.AddWithValue("@username", user)
    cmd.Parameters.AddWithValue("@password", pass)
    connection.Open()
   
    Dim dt As New DataTable()
    Dim ad As New SqlDataAdapter(cmd)
    ad.Fill(dt)
    If dt.Rows.Count > 0 Then
        'check if the query returns any data
        Response.Redirect("Default.aspx")
    Else
        Response.Write("INVALID Username and Password, Try Again!")
    End If
    connection.Close()
End Sub

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1_Click
    ValidateUserInfo(TextUserName.Text.Trim(), TextPassword.Text.Trim())
End Sub

这么简单！祝您编码愉快！

That simple! Happy Coding!

请尝试以下操作:

ASP.NET和Access的简单登录和重定向
创建表单的凭据存储ASP.NET 3.5中的身份验证
登录后如何重定向到特定页面?
如何在登录后重定向到特定页面?

ASP.NET登录控件概述
成员资格简介
ASP.NET中的表单身份验证

Try following:

Simple Login and Redirect for ASP.NET and Access
Creating Credential Store for Form Authentication in ASP.NET 3.5
how to redirect to particular page after login?
how to redirect to particular page after login?

ASP.NET Login Controls Overview
Introduction to Membership
Forms Authentication in ASP.NET

这篇关于嗨，如果用户名和密码有效，如何重定向到另一个页面?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！