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

~ Access db backend ~<\/strong><\/p>\n

Web.config<\/strong><\/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<\/strong><\/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”\u00a0 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<\/strong><\/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

‘\/ 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”)
\nDim cmd As New OleDbCommand(“SELECT * FROM Login WHERE (username = ‘” & usn.Text.ToString() & “‘) AND (password = ” & pwd.Text.ToString() & “);”, ConnDB)
\nDim 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()
\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()\u00a0\u00a0\u00a0\u00a0 ‘\/ 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 ~ 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”\u00a0 TextMode=”password” \/> <asp:RequiredFieldValidator ID=”ReqVal_1″ controltovalidate=”usn” validationgroup=”Login1″ runat=”server” ErrorMessage=” ? ” > <\/asp:RequiredFieldValidator> <\/td> <\/tr> <tr> <td>Teller #: <\/td><td style=”color: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,16],"tags":[19,20,22,21],"class_list":["post-265","post","type-post","status-publish","format-standard","hentry","category-applications","category-net","tag-asp-net","tag-login","tag-programming","tag-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/265"}],"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=265"}],"version-history":[{"count":15,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/265\/revisions"}],"predecessor-version":[{"id":443,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/265\/revisions\/443"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}