login control help..

chazze06 · #1 (**permalink**) 04-22-08, 11:09 PM

i don;t know how to make a login control.. and i don't know how will make it work.. can someone help me.. my databse is an excel file..where the username and passwords are stored.. there will be 2 catgeries of a users, an ADMIN and a USER.. pls help.. i really dont know what to do..

digioz · #2 (**permalink**) 04-23-08, 10:00 AM

ASP.NET 2.0 comes with a login control:

ASP_NET_Login_Control.jpg

Or are you asking for the whole system (coding included)?

Pete

chazze06 · #3 (**permalink**) 04-24-08, 10:00 PM

yes.. i don't know how to code.. i don't understand how ASP.net 2.0 works.. i'm really having a hard time figuring it out really..

digioz · #4 (**permalink**) 04-25-08, 12:58 PM

Here is a very simple example on how to do this.

Database:

Type: Microsoft Excel
File Name: users.xls
Sheet Name: users

users.gif

Login WebForm Code:

HTML Code:

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="login.aspx.vb" Inherits="SimpleLogin._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Login ID="Login1" runat="server">
        </asp:Login>
    
    </div>
    </form>
</body>
</html>

Login Code Behind:

vb.net Code:

Imports System.Data.OleDb
Partial Public Class _Default
    Inherits System.Web.UI.Page
    Private Shared lsConnectionString As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim lsPath As String = Request.PhysicalApplicationPath & "users.xls"
        lsConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & lsPath & ";Extended Properties=Excel 8.0;"
    End Sub
    Protected Sub Login1_Authenticate(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
        Dim lsQuery As String = "SELECT * FROM [users$]"
        Dim loConnection = New OleDbConnection(lsConnectionString)
        Dim loCommand As New OleDbCommand(lsQuery, loConnection)
        Dim lsUsername, lsPassword, lsUserType As String
        Dim loReader As IDataReader
        loConnection.Open()
        loReader = loCommand.ExecuteReader()
        While (loReader.Read())
            lsUsername = CStr((loReader("username")))
            lsPassword = CStr((loReader("password")))
            lsUserType = CStr((loReader("usertype")))
            If Login1.UserName = lsUsername AndAlso Login1.Password = lsPassword Then
                Response.Write("Login Successful!")
                e.Authenticated = True
                Session("Authenticated") = True
                Session("username") = lsUsername
                Session("password") = lsPassword
                Session("usertype") = lsUserType
                Response.Redirect("Default.aspx")
                Exit While
            End If
        End While
    End Sub
End Class

Success Web Form:

HTML Code:

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="SimpleLogin._Default1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>

Success Code Behind:

vb.net Code:

Public Partial Class _Default1
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Session("Authenticated") = True Then
            Response.Write("Welcome " & Session("username") & "!<br />")
            Response.Write("User Type: " & Session("usertype"))
        Else
            Response.Redirect("Login.aspx")
        End If
    End Sub
End Class

Sample Project is attached bellow. I hope this helps!

Pete

chazze06 · #5 (**permalink**) 04-26-08, 02:55 AM

sir digioz.. thank you for the sample project.. i'll try this when i get home.. i'll post some questions again when i don't understand it.. thanks a lot1

chazze06 · #6 (**permalink**) 05-08-08, 01:58 AM

sir digioz.. uhm.. how would i make a web.config?.. i used the excel but i had a problem making a delete query so i changed back to access.. how do i make an authentication?.. for example, a user can't access the other pages if he/she is not logged in.. the page should redirect him/her to the login page.. thanks for the sample code.. it was really helpful.. uhm can u give another sample, this time using c#? thanks again! ÜÜ

digioz · #7 (**permalink**) 05-08-08, 10:00 AM

Read the section marked "Success Code Behind" above. The same applies for Microsoft Access as far as checking to see if the user is logged in or not.

Pete