{"id":807,"date":"2011-05-25T16:34:44","date_gmt":"2011-05-25T20:34:44","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=807"},"modified":"2011-07-01T12:42:14","modified_gmt":"2011-07-01T16:42:14","slug":"asp-net-login-page-with-sql-backend","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2011\/05\/asp-net-login-page-with-sql-backend\/","title":{"rendered":"ASP.NET Login Page with SQL Backend"},"content":{"rendered":"

Let’s start simple by creating form controls:<\/strong><\/p>\n

\"\"<\/a><table>
\n<tr><td>Usernname<\/td><td><asp:TextBox ID=”user” runat=”server”><\/asp:TextBox><\/td><\/tr>
\n<tr><td>Password<\/td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”><\/asp:TextBox><\/td><\/tr>
\n<tr><td><\/td><td><asp:Button ID=”Button1″ OnClick=”submit” Text=”Login” runat=”server” causesValidation=”true” \/><\/td><\/tr>
\n<\/table><\/p><\/blockquote>\n

Now add some form validation:<\/strong><\/p>\n

\"\"<\/a><\/p>\n

<table>
\n<tr><td>Usernname<\/td><td><asp:TextBox ID=”user” runat=”server”><\/asp:TextBox>
\n<asp:RequiredFieldValidator<\/span>
\n ID=”RequiredFieldValidator1″<\/span>
\n runat=”server”<\/span>
\n ControlToValidate=”user”<\/span>
\n ValidationGroup=”UserCheck”<\/span>
\n ErrorMessage=” <font color=’red’> &laquo; Username is required!<\/font> “><\/span>
\n <\/asp:RequiredFieldValidator><\/span>
\n<\/td><\/tr>
\n<tr><td>Password<\/td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”><\/asp:TextBox>
\n<asp:RequiredFieldValidator<\/span>
\n ID=”RequiredFieldValidator2″<\/span>
\n runat=”server”<\/span>
\n ControlToValidate=”password”<\/span>
\n ValidationGroup=”UserCheck”<\/span>
\n ErrorMessage=” <font color=’red’> &laquo; Username is required!<\/font> “><\/span>
\n <\/asp:RequiredFieldValidator><\/span>
\n<\/td><\/tr>
\n<tr><td><\/td><td><asp:Button ID=”Button1″ OnClick=”submit” Text=”Login” runat=”server”
\ncausesValidation=”true” ValidationGroup=”UserCheck” \/><\/td><\/tr>
\n<\/table><\/p><\/blockquote>\n

Here we add some encryption:<\/strong><\/p>\n

Dim sha1Obj As New System.Security.Cryptography.SHA1CryptoServiceProvider
\nDim bytesToHash() As Byte = System.Text.Encoding.ASCII.GetBytes(pwd)
\nbytesToHash = sha1Obj.ComputeHash(bytesToHash)<\/p><\/blockquote>\n

And that should be it – one page login script with SQL backend:<\/strong><\/p>\n

\"\"<\/a>Default.aspx<\/strong>
\n<%@ Page Title=”Home Page” Language=”vb” MasterPageFile=”~\/Site960.Master” AutoEventWireup=”false” CodeBehind=”Default.aspx.vb”\u00a0 %>
\n<asp:Content ID=”HeaderContent” runat=”server” ContentPlaceHolderID=”HeadContent”>
\n<script runat=”server”>
\nSub submit(sender As Object, e As EventArgs)<\/p>\n

Session(“user”) = user.Text()
\nSession(“password”) = password.Text()<\/p>\n

Dim sid As String
\nDim pwd As String<\/p>\n

sid = user.Text.ToString()
\npwd = password.Text.ToString()<\/p>\n

Dim sha1Obj As New System.Security.Cryptography.SHA1CryptoServiceProvider
\nDim bytesToHash() As Byte = System.Text.Encoding.ASCII.GetBytes(pwd)
\nbytesToHash = sha1Obj.ComputeHash(bytesToHash)<\/p>\n

sid = Session(“user”)
\nIf sid <> “” Then
\nDim keyCode As String = “”
\nFor Each b As Byte In bytesToHash
\nkeyCode += b.ToString(“x2”)
\nNext<\/p>\n

Dim ConnDB As New Data.OleDb.OleDbConnection(“Provider=SQLOLEDB;Data Source=MyServer;Initial Catalog=intranet;Persist Security Info=True;User ID=myUserID;Password=MyPwd;”) ‘\/ create connection
\nDim cmd As New Data.OleDb.OleDbCommand(“SELECT * FROM User_Tbl WHERE (username = ‘” & user.Text.ToString() & “‘) AND (password = ‘” & keyCode & “‘);”, ConnDB)\u00a0\u00a0\u00a0 ‘\/ query recordset
\nDim reader As Data.OleDb.OleDbDataReader\u00a0 ‘\/ define reader<\/p>\n

Try<\/p>\n

cmd.Connection.Open()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\/ open connection
\nreader = cmd.ExecuteReader()\u00a0 ‘\/ execute reader<\/p>\n

If reader.Read() Then
\nSession(“Name”) = reader(1).ToString()\u00a0 ‘\/ write user name session
\nLabel1.Text = (“<img src=’images\/checkMark.png’> <font color=’green’>Login successful ” & reader(1).ToString & “!<\/font><p><a href=’SecurePage.aspx?tsr=” & user.Text() & “&dt=” & DateTime.Now.ToShortDateString() & “‘>Continue &raquo;<\/a><\/p>”)
\n‘\/ label1 – acknowledge user, username valid, access granted
\nElse
\nLabel1.Text = (“<font color=’red’>Login failed!<\/font><br \/>Try again, if problem persists submit case to Help Desk!”)
\n‘\/ label1 – unknown username, decline access
\nEnd If<\/p>\n

cmd.Connection.Close()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\/ close connection<\/p>\n

Catch ex As Exception\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\/ in case of exception
\nLabel1.Text = “ERROR: ” & ex.Message.ToString()\u00a0 ‘\/ get an error message, just in case
\nEnd Try<\/p>\n

End If<\/p>\n

End Sub
\n<\/script>
\n<\/asp:Content>
\n<asp:Content ID=”BodyContent” runat=”server” ContentPlaceHolderID=”MainContent”>
\n<div>
\n<h1>Insurance Form Look up<\/h1>
\n<%
\nDim job As String
\njob = Request.QueryString(“do”)<\/p>\n

If job = “” Then
\n%>
\n<p>In order to access your record(s) you must login. To login select login profile on the left side navigaiton menu.<\/p>
\n<%
\nEnd If
\nIf job = “admlog” Then
\n%>
\n<p>
\n<table>
\n<tr><td>Usernname<\/td><td><asp:TextBox ID=”user” runat=”server”><\/asp:TextBox>
\n<asp:RequiredFieldValidator
\nID=”RequiredFieldValidator1″
\nrunat=”server”
\nControlToValidate=”user”
\nValidationGroup=”UserCheck”
\nErrorMessage=” <font color=’red’> &laquo; Username is required!<\/font> “>
\n<\/asp:RequiredFieldValidator>
\n<\/td><\/tr>
\n<tr><td>Password<\/td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”><\/asp:TextBox>
\n<asp:RequiredFieldValidator
\nID=”RequiredFieldValidator2″
\nrunat=”server”
\nControlToValidate=”password”
\nValidationGroup=”UserCheck”
\nErrorMessage=” <font color=’red’> &laquo; Username is required!<\/font> “>
\n<\/asp:RequiredFieldValidator>
\n<\/td><\/tr>
\n<tr><td><\/td><td><asp:Button ID=”Button1″ OnClick=”submit” Text=”Login” runat=”server”
\ncausesValidation=”true” ValidationGroup=”UserCheck” \/><\/td><\/tr>
\n<\/table>
\n<\/p>
\n<%
\nEnd If
\n%>
\n<p>
\n<asp:Label id=”Label1″ runat=”server”><\/asp:Label>
\n<\/p><\/p>\n

<%
\n‘Dim job As String
\njob = Request.QueryString(“do”)
\nIf job = “logout” Then<\/p>\n

Session.Abandon()<\/p>\n

Response.Write(“<img src=’images\/checkMark.png’> &raquo; <font color=’green’>Sesion closed!<\/font>”)
\nEnd If<\/p>\n

%>
\n<\/div><\/p>\n

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

Let’s start simple by creating form controls: <table> <tr><td>Usernname<\/td><td><asp:TextBox ID=”user” runat=”server”><\/asp:TextBox><\/td><\/tr> <tr><td>Password<\/td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”><\/asp:TextBox><\/td><\/tr> <tr><td><\/td><td><asp:Button ID=”Button1″ OnClick=”submit” Text=”Login” runat=”server” causesValidation=”true” \/><\/td><\/tr> <\/table> Now add some form validation: <table> <tr><td>Usernname<\/td><td><asp:TextBox ID=”user” runat=”server”><\/asp:TextBox> <asp:RequiredFieldValidator ID=”RequiredFieldValidator1″ runat=”server” ControlToValidate=”user” ValidationGroup=”UserCheck” ErrorMessage=” <font color=’red’> &laquo; Username is required!<\/font> “> <\/asp:RequiredFieldValidator> <\/td><\/tr> <tr><td>Password<\/td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”><\/asp:TextBox> <asp:RequiredFieldValidator ID=”RequiredFieldValidator2″ runat=”server” ControlToValidate=”password” […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,33,29,32],"tags":[19,31,20,22,21],"class_list":["post-807","post","type-post","status-publish","format-standard","hentry","category-applications","category-classic-asp","category-encryption","category-ms-sql","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\/807"}],"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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=807"}],"version-history":[{"count":15,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/807\/revisions"}],"predecessor-version":[{"id":970,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/807\/revisions\/970"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}