So, whenever someone do a registration, the data values are automatically stored in the database when btnSubmit is Clicked...
My problem is that, I want to use the UserName value and the Password value from the Registration table to be Used as Login Credentials..
I'm trying not to use the login Controls but rather by using labels and Textboxes
My sql connection:
<connectionStrings> <add name="jjshopconn" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\JJS.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings>
Here's my code For The Registration aspx.vb:
Imports System.Data Imports System.Data.SqlClient Imports System.Web.Configuration Partial Class JJS_Register Inherits System.Web.UI.Page Private ReadOnly _conString As String Public Sub New() _conString = WebConfigurationManager.ConnectionStrings("jjshopconn").ConnectionString End Sub Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim con As New SqlConnection(_conString) Dim insertSql As String = "INSERT INTO tbl_Customer (Cust_fname,Cust_lname,Cust_uname,Cust_pwd,Cust_email,Cust_status)" & " values (@FirstName,@LastName,@UserName,@Password,@Email,@Status)" Dim con1 As New SqlConnection(_conString) Dim cmd As New SqlCommand() cmd.Connection = con cmd.CommandType = CommandType.Text cmd.CommandText = insertSql Dim firstName As New SqlParameter("@FirstName", SqlDbType.VarChar, 50) firstName.Value = txtFirstName.Text.ToString() cmd.Parameters.Add(firstName) Dim lastName As New SqlParameter("@LastName", SqlDbType.VarChar, 50) lastName.Value = txtLastName.Text.ToString() cmd.Parameters.Add(lastName) Dim userName As New SqlParameter("@UserName", SqlDbType.VarChar, 50) userName.Value = txtUserName.Text.ToString() cmd.Parameters.Add(userName) Dim pwd As New SqlParameter("@Password", SqlDbType.VarChar, 50) pwd.Value = txtPassword.Text.ToString() cmd.Parameters.Add(pwd) Dim email As New SqlParameter("@Email", SqlDbType.VarChar, 50) email.Value = txtEmail.Text.ToString() cmd.Parameters.Add(email) Dim status As New SqlParameter("@Status", SqlDbType.VarChar, 10) status.Value = drpStatus.SelectedItem.ToString() cmd.Parameters.Add(status) Try con.Open() cmd.ExecuteNonQuery() lblMsg.Text = "User Registration successful" Catch ex As SqlException Dim errorMessage As String = "Error in registering user" errorMessage += ex.Message Throw New Exception(errorMessage) Finally con.Close() End Try End Sub End Class
The Design Layer:
<asp:Content ID="Content5" ContentPlaceHolderID="Register" Runat="Server"> <div class="center_content"> <h2>Create a New Account</h2> <p>Use the form below to create a new account.</p> <p>Passwords are required to be a minimum of 6 characters in length.</p> <span class="failureNotification"> <asp:Literal ID="ErrorMessage" runat="server"></asp:Literal> </span> <div class="accountInfo"> <fieldset class="register" style="width: 500px"> <legend>Account Information</legend> <p> <asp:Label ID="lblFirstName" runat="server" AssociatedControlID="txtFirstName">First Name:</asp:Label> <asp:TextBox ID="txtFirstName" runat="server" CssClass="textEntry"> </asp:TextBox> <asp:RequiredFieldValidator ID="FirstNameRequired" runat="server" ControlToValidate="txtFirstName" CssClass="failureNotification" Text="First Name is required." SetFocusonerror="True" /> </p> <p> <asp:Label ID="lblLastName" runat="server" AssociatedControlID="txtLastName">Last Name:</asp:Label> <asp:TextBox ID="txtLastName" runat="server" CssClass="textEntry"></asp:TextBox> <asp:RequiredFieldValidator ID="LastNameRequired" runat="server" ControlToValidate="txtLastName" CssClass="failureNotification" Text="Last Name is required." SetFocusonerror="True" /> </p> <p> <asp:Label ID="lblUserName" runat="server" AssociatedControlID="txtUserName">User Name:</asp:Label> <asp:TextBox ID="txtUserName" runat="server" CssClass="textEntry"></asp:TextBox> <asp:RequiredFieldValidator ID="UserNameRequired" runat="server" ControlToValidate="txtUserName" CssClass="failureNotification" Text="User Name is required." SetFocusonerror="True" /> </p> <p> <asp:Label ID="lblPwd" runat="server" AssociatedControlID="txtPassword">Password:</asp:Label> <asp:TextBox ID="txtPassword" runat="server" CssClass="passwordEntry" TextMode="Password" Width="128px"></asp:TextBox> <asp:RequiredFieldValidator ID="PasswordRequired" runat="server" ControlToValidate="txtPassword" CssClass="failureNotification" Text="Password is required." SetFocusonerror="True" /> </p> <p> <asp:Label ID="lblConfPwd" runat="server" AssociatedControlID="txtConfPwd">Confirm Password:</asp:Label> <asp:TextBox ID="txtConfPwd" runat="server" CssClass="passwordEntry" TextMode="Password" ></asp:TextBox> <asp:RequiredFieldValidator ControlToValidate="txtConfPwd" CssClass="failureNotification" Display="Dynamic" Text="Confirm Password is required." ID="ConfirmPasswordRequired" runat="server" SetFocusonerror="True"/> <asp:CompareValidator ID="PasswordCompare" runat="server" ControlToCompare="txtPassword" ControlToValidate="txtConfPwd" CssClass="failureNotification" Display="Dynamic" Text="The Password and Confirmation Password must match." /> </p> <p> <asp:Label ID="lblEmail" runat="server" AssociatedControlID="txtEmail">E-mail:</asp:Label> <asp:TextBox ID="txtEmail" runat="server" CssClass="textEntry"></asp:TextBox> <asp:RequiredFieldValidator ID="EmailRequired" runat="server" ControlToValidate="txtEmail" CssClass="failureNotification" Text="E-mail is required." ToolTip="E-mail is required." SetFocusonerror="True" /> <asp:RegularExp<b></b>ressionValidator ID="RegularExp<b></b>ressionValidator1" runat="server" ValidationExp<b></b>ression="\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" ControlToValidate="txtEmail" CssClass="failureNotification" Text="Invalid Email Format. Re-Type Email!!"></asp:RegularExp<b></b>ressionValidator> </p> <p> <asp:Label ID="lblStatus" runat="server" AssociatedControlID="drpStatus">Status:</asp:Label> <asp:DropDownList ID="drpStatus" runat="server"> <asp:ListItem Selected="True">--Select Status--</asp:ListItem> <asp:ListItem>Single</asp:ListItem> <asp:ListItem>Married</asp:ListItem> </asp:DropDownList> </p> <p> <asp:Button ID="btnSubmit" runat="server" CssClass="Notification" Text="Register" /> </p> <p> <asp:Label ID="lblMsg" runat="server"> </asp:Label> </p> </fieldset> </div> </div> </asp:Content>
Now My Login Form .aspx:
<div class="center_content"> <h2 > Log In </h2> <p> Please enter your username and password. <asp:HyperLink ID="RegisterHyperLink" NavigateUrl="~/JJS/Register.aspx" Text="Register" runat="server" EnableViewState="false">Register</asp:HyperLink> if you don't have an account. </p> <div id="accountInfo"> <fieldset id="login" style="width: 450px"> <legend>Account Information</legend> <p> <asp:Label ID="UserNameLabel" runat="server" AssociatedControlID="UserName">Username:</asp:Label> <asp:TextBox ID="UserName" runat="server" CssClass="textEntry"></asp:TextBox> <asp:RequiredFieldValidator ID="UserNameRequired" runat="server" ControlToValidate="UserName" CssClass="failureNotification" ErrorMessage="User Name is required." ToolTip="User Name is required." ValidationGroup="LoginUserValidationGroup">*</asp:RequiredFieldValidator> </p> <p> <asp:Label ID="PasswordLabel" runat="server" AssociatedControlID="Password">Password:</asp:Label> <asp:TextBox ID="Password" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox> <asp:RequiredFieldValidator ID="PasswordRequired" runat="server" ControlToValidate="Password" CssClass="failureNotification" ErrorMessage="Password is required." ToolTip="Password is required." ValidationGroup="LoginUserValidationGroup">*</asp:RequiredFieldValidator> </p> <p> <asp:CheckBox ID="RememberMe" runat="server"/> <asp:Label ID="RememberMeLabel" runat="server" AssociatedControlID="RememberMe" CssClass="inline">Keep me logged in</asp:Label> </p> <p> <asp:Button ID="btnLogin" runat="server" Text="Log In" /> </p> <p> </p> </fieldset> </div> </div>
The Code-Behind:
Imports System.Data Imports System.Data.SqlClient Imports System.Web.Configuration Imports System.Collections Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Partial Class JJS_Main Inherits System.Web.UI.Page Private ReadOnly _conString As String Public Sub New() _conString = WebConfigurationManager.ConnectionStrings("jjshopconn").ConnectionString End Sub Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim con As New SqlConnection(_conString) Dim sqlstring As String = "SELECT * FROM tbl_Customer WHERE (Cust_uname ='" & UserName.Text & "' AND Cust_pwd ='" & Password.Text & "')" Dim comm As New System.Data.SqlClient.SqlCommand(sqlstring, con) Dim reader As System.Data.SqlClient.SqlDataReader con.Open() reader = comm.ExecuteReader() If reader.Read() Then Response.Redirect("Default.aspx") Else lblStatus.Text = "Try Again! Please Re-Enter your Login and Password!" End If con.Close() End Sub End Class
If you could help me Please...