
10/01/2003, 06:38
|
 | | | Fecha de Ingreso: diciembre-2002
Mensajes: 131
Antigüedad: 22 años, 4 meses Puntos: 0 | |
Lo que necesito es que mi asp del login si entro con una clave y un nombre 1 me redireccione a una pagina a en html y si entro con otro nombre y clave a otra pagina b tambien en html. Mi codigo del login es:
<%@ Page Language="VB" %>
<script runat="server">
Sub LoginBtn_Click(Sender As Object, E As EventArgs)
If Page.IsValid Then
Dim userDS As New System.Data.DataSet
userDS = GetUser(UserName.Text, UserPass.Text)
If userDS.Tables(0).Rows.Count = 1 Then
FormsAuthentication.RedirectFromLoginPage(UserName .Text, true)
Else
Msg.Text = "Invalid Credentials: Please try again"
End If
End If
End Sub
Function GetUser(ByVal userName As String, ByVal userPassword As String) As System.Data.DataSet
Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='Galeria'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng)
Dim queryString As String = "SELECT [Users].* FROM [Users] WHERE (([Users].[UserName] = @UserName) AND ([Users"& _
"].[UserPassword] = @UserPassword))"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
sqlCommand.Parameters.Add("@UserName", System.Data.SqlDbType.VarChar).Value = userName
sqlCommand.Parameters.Add("@UserPassword", System.Data.SqlDbType.VarChar).Value = userPassword
Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<form runat="server">
<h2>Login Page
</h2>
<hr size="1" />
<table>
<tbody>
<tr>
<td>
Username:</td>
<td>
<asp:TextBox id="UserName" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator id="Requiredfieldvalidator1" runat="server" ErrorMessage="*" Display="Static" ControlToValidate="UserName"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Password:</td>
<td>
<asp:TextBox id="UserPass" runat="server" TextMode="Password"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator id="Requiredfieldvalidator2" runat="server" ErrorMessage="*" Display="Static" ControlToValidate="UserPass"></asp:RequiredFieldValidator>
</td>
</tr>
</tbody>
</table>
<asp:button id="LoginBtn" onclick="LoginBtn_Click" runat="server" text="Login"></asp:button>
<p>
<asp:Label id="Msg" runat="server" ForeColor="red"></asp:Label>
</p>
</form>
</body>
</html> |