{"id":276,"date":"2010-12-27T14:46:21","date_gmt":"2010-12-27T18:46:21","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=276"},"modified":"2011-01-17T17:17:30","modified_gmt":"2011-01-17T21:17:30","slug":"asp-net-login-application-access-db-backend-sha1-or-md5-encryption","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2010\/12\/asp-net-login-application-access-db-backend-sha1-or-md5-encryption\/","title":{"rendered":"Login"},"content":{"rendered":"

~ Access db backend & SHA1 or MD5 encryption ~<\/strong>
\n<\/strong><\/p>\n

Web.config<\/p>\n

<system.web><\/p>\n

<authentication mode=”Forms”>
\n<forms loginUrl=”Login.aspx” timeout=”2880″\/>
\n<\/authentication><\/p>\n

<\/system.web><\/p><\/blockquote>\n

Login.aspx<\/p>\n

<form id=”form1″ runat=”server” >
\n<table >
\n<tr>
\n<td colspan=”2″><b>Login Form<\/b><\/td>
\n<\/tr>
\n<tr>
\n<td>Intranet Username: <\/td><td style=”color: Red;” >
\n<asp:TextBox ID=”usn” runat=”server” TextMode=”password” \/>
\n<asp:RequiredFieldValidator ID=”ReqVal_1″ controltovalidate=”usn”
\nvalidationgroup=”Login1″ runat=”server” ErrorMessage=” ? ” >
\n<\/asp:RequiredFieldValidator>
\n<\/td>
\n<\/tr>
\n<tr>
\n<td>Teller #: <\/td><td style=”color: Red;” ><asp:TextBox ID=”pwd” runat=”server” TextMode=”password” \/>
\n<asp:RequiredFieldValidator ID=”ReqVal_2″ controltovalidate=”pwd”
\nvalidationgroup=”Login1″ runat=”server” ErrorMessage=” ? ” >
\n<\/asp:RequiredFieldValidator>
\n<asp:RegularExpressionValidator runat=”server” ErrorMessage=”Numbers only.”
\nControlToValidate=”pwd” validationgroup=”Login1″ ValidationExpression=”^\\d+$” \/><\/asp:RegularExpressionValidator>
\n<\/td>
\n<\/tr>
\n<tr>
\n<td><\/td>
\n<td ><asp:Label ID=”Label1″ runat=”server” \/><br \/>
\n<asp:Label ID=”Label2″ runat=”server” \/><\/td>
\n<\/tr>
\n<tr>
\n<td><\/td><td ><asp:Button ID=”submit” runat=”server” Text=”submit”
\nCausesValitdation=”True” ValidationGroup=”Login1″ \/><\/p>\n

<\/td>
\n<\/tr>
\n<\/table>
\n<\/form><\/p><\/blockquote>\n

Loginn.aspx.vb<\/p>\n

Imports System.IO
\nImports System.Data.OleDb
\nImports System.Web.UI.WebControls.Button
\nImports System.Web.UI.WebControls.TextBox
\nImports System.Web.SessionState
\nImports System.Web.Security<\/p>\n

Partial Class Login
\nInherits System.Web.UI.Page<\/p>\n

Protected Sub submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit.Click
\n‘defining variables\/controls
\nDim usn As TextBox
\nDim pwd As TextBox<\/p>\n

‘binding controls
\nusn = submit.FindControl(“usn”)
\npwd = submit.FindControl(“pwd”)<\/p>\n

‘\/ here are 2 encryption methods
\n‘********************************’
\nDim key<\/strong> As String
\nDim key1 As String
\nkey<\/strong> = FormsAuthentication.HashPasswordForStoringInConfigFile(“pwd”, “SHA1”)\u00a0\u00a0 ‘\/ here we implement SHA1 hash
\nkey1 = FormsAuthentication.HashPasswordForStoringInConfigFile(“pwd”, “MD5”)\u00a0\u00a0 ‘\/ here we implement MD5 hash<\/p>\n

‘\/ access db connection – MS Access 2007\/10 driver * you can define your own sql connection
\nDim ConnDB As New OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\/myDB.mdb;Persist Security Info=True”)<\/p>\n

Dim cmd As New OleDbCommand(“SELECT * FROM Login WHERE (username = ‘” & usn.Text.ToString() & “‘) AND (password = ” & key<\/strong>.Text.ToString() & “);”, ConnDB)<\/p>\n

‘\/ simple replace “key” with “key1” to use MD5 encryption method<\/p>\n

Dim reader As OleDbDataReader<\/p>\n

Try<\/p>\n

‘\/ open connection
\ncmd.Connection.Open()
\nreader = cmd.ExecuteReader()
\nIf reader.Read() Then
\nLabel1.Text = (“<font color=’green’>You are logged in!<\/font>”)
\nSession(“Name”) = reader(1).ToString()\u00a0\u00a0\u00a0\u00a0 ‘\/ write session “Name” so you can greet user after successful login
\nResponse.Redirect(“MySecurePage.aspx”)
\nElse
\nLabel1.Text = (“<font color=’red’>Wrong Username or Password!<\/font>”)
\nEnd If<\/p>\n

cmd.Connection.Close()<\/p>\n

‘\/ end
\nCatch ex As Exception
\nLabel2.Text = “ERROR: ” & ex.Message.ToString() ‘\/ in case of error<\/p>\n

End Try<\/p>\n

End Sub<\/p>\n

End Class<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

~ Access db backend & SHA1 or MD5 encryption ~ Web.config <system.web> <authentication mode=”Forms”> <forms loginUrl=”Login.aspx” timeout=”2880″\/> <\/authentication> <\/system.web> Login.aspx <form id=”form1″ runat=”server” > <table > <tr> <td colspan=”2″><b>Login Form<\/b><\/td> <\/tr> <tr> <td>Intranet Username: <\/td><td style=”color: Red;” > <asp:TextBox ID=”usn” runat=”server” TextMode=”password” \/> <asp:RequiredFieldValidator ID=”ReqVal_1″ controltovalidate=”usn” validationgroup=”Login1″ runat=”server” ErrorMessage=” ? ” > <\/asp:RequiredFieldValidator> <\/td> <\/tr> […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,17,16],"tags":[30,19,31,20,22,21],"class_list":["post-276","post","type-post","status-publish","format-standard","hentry","category-access","category-applications","category-net","tag-access-2","tag-asp-net","tag-encryption-2","tag-login","tag-programming","tag-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/276"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=276"}],"version-history":[{"count":17,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/276\/revisions"}],"predecessor-version":[{"id":442,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/276\/revisions\/442"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}