Create SignUp Form With Login Form And Database In ASP.NET Web Forms
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="LOGIN.aspx.cs" Inherits="LOGIN_FORM_ASP_PRACTICE.LOGIN" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1{
text-align:center;
font-size:30px;
}
.auto-style2 {
width: 99px;
}
table{
margin:auto;
width:300px;
border:5px black ridge;
}
.link{
text-align:center;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table cellpadding="4" cellspacing="4">
<tr>
<td class="auto-style1" colspan="2">LOGIN</td>
</tr>
<tr>
<td class="auto-style2">USERNAME</td>
<td>
<asp:TextBox ID="UsernameTextBox" runat="server" Width="192px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Please Enter Username" Display="Dynamic" ForeColor="Red" ControlToValidate="UsernameTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2">PASSWORD</td>
<td>
<asp:TextBox ID="PasswordTextBox" runat="server" Width="192px" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="Please Enter Password" Display="Dynamic" ForeColor="Red" ControlToValidate="PasswordTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2"> </td>
<td>
<asp:Button ID="LoginButton" runat="server" Text="LOGIN" OnClick="LoginButton_Click"/>
</td>
</tr>
<tr>
<td class="link" colspan="2">
<a href="REGISTER.aspx">Not Registered yet ? Click Here</a>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Above File is LOGIN_FORM_ASP_PRACTICE\LOGIN.aspx
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
namespace LOGIN_FORM_ASP_PRACTICE
{
public partial class LOGIN : System.Web.UI.Page
{
string cs = ConfigurationManager.ConnectionStrings["dbcs2"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void LoginButton_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string query = "SELECT * FROM signup WHERE username=@username AND password=@password";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@username", UsernameTextBox.Text);
cmd.Parameters.AddWithValue("@password", PasswordTextBox.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
Session["user"] = UsernameTextBox.Text;
//Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Login Successful !!')</script>");
Response.Redirect("DASHBOARD.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Login Failed !!')</script>");
}
}
}
catch (SqlException ex)
{
Response.Write("Exception: " + ex.Message);
}
catch (Exception ex)
{
Response.Write("Exception: " + ex.Message);
}
}
}
}
Above File is LOGIN_FORM_ASP_PRACTICE\LOGIN.aspx.cs
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="REGISTER.aspx.cs" Inherits="LOGIN_FORM_ASP_PRACTICE.REGISTER" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1{
width:500px;
margin:auto;
border:ridge 5px black;
}
.auto-style2 {
width: 166px;
}
.auto-style3{
text-align:center;
font-size:30px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table cellpadding="3" cellspacing="3" class="auto-style1">
<tr>
<td class="auto-style3" colspan="2">SIGNUP FORM</td>
</tr>
<tr>
<td class="auto-style2">FIRST NAME</td>
<td>
<asp:TextBox ID="FirstNameTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter first name" ForeColor="Red" ControlToValidate="FirstNameTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2">LAST NAME</td>
<td>
<asp:TextBox ID="LastNameTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter last name" ForeColor="Red" ControlToValidate="LastNameTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2">GENDER</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server" Width="218px">
<asp:ListItem Value="Select">Select</asp:ListItem>
<asp:ListItem Value="Male">Male</asp:ListItem>
<asp:ListItem Value="Female">Female</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator InitialValue="Select" ID="RequiredFieldValidator3" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please select a gender" ForeColor="Red" ControlToValidate="DropDownList1" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2">EMAIL</td>
<td>
<asp:TextBox ID="EmailTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter email" ForeColor="Red" ControlToValidate="EmailTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter correct email" ForeColor="Red" ControlToValidate="EmailTextBox" SetFocusOnError="true" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*</asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td class="auto-style2">ADDRESS</td>
<td>
<asp:TextBox ID="AddressTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter address" ForeColor="Red" ControlToValidate="AddressTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2">USERNAME</td>
<td>
<asp:TextBox ID="UsernameTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter username" ForeColor="Red" ControlToValidate="UsernameTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style2">PASSWORD</td>
<td>
<asp:TextBox ID="PasswordTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter password" ForeColor="Red" ControlToValidate="PasswordTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter a strong password with uppercase,lowercase,numbers and characters" ForeColor="Red" ControlToValidate="PasswordTextBox" SetFocusOnError="true" ValidationExpression="(?=^.{8,}$)((?=.*\d)|(?=.*\W+))(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td class="auto-style2">CONFIRM PASSWORD</td>
<td>
<asp:TextBox ID="ConfirmPasswordTextBox" runat="server" Width="218px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" Display="Dynamic" Text="*" ErrorMessage="Please enter confirm password" ForeColor="Red" ControlToValidate="ConfirmPasswordTextBox" SetFocusOnError="true"></asp:RequiredFieldValidator>
<asp:CompareValidator ID="CompareValidator1" runat="server" Display="Dynamic" Text="*" ErrorMessage="Password is not identical" ForeColor="Red" ControlToValidate="ConfirmPasswordTextBox" ControlToCompare="PasswordTextBox" SetFocusOnError="true"></asp:CompareValidator>
</td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="SignUpButton" runat="server" Text="SIGNUP" Height="42px" Width="113px" OnClick="SignUpButton_Click"/>
</td>
</tr>
<tr>
<td> </td>
<td>
<a href="LOGIN.aspx">GO TO LOGIN FORM</a>
</td>
</tr>
</table>
<asp:ValidationSummary ID="ValidationSummary1" runat="server" BackColor="#CCCCCC" ForeColor="Red" Font-Size="Larger"/>
</div>
</form>
</body>
</html>
Above File is LOGIN_FORM_ASP_PRACTICE\REGISTER.aspx
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace LOGIN_FORM_ASP_PRACTICE
{
public partial class REGISTER : System.Web.UI.Page
{
string cs = ConfigurationManager.ConnectionStrings["dbcs2"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void SignUpButton_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string query = "INSERT INTO signup(fname,lname,gender,email,address,username,password) VALUES(@fname,@lname,@gender,@email,@address,@username,@password)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@fname", FirstNameTextBox.Text);
cmd.Parameters.AddWithValue("@lname", LastNameTextBox.Text);
cmd.Parameters.AddWithValue("@gender", DropDownList1.SelectedItem.Value);
cmd.Parameters.AddWithValue("@email", EmailTextBox.Text);
cmd.Parameters.AddWithValue("@address", AddressTextBox.Text);
cmd.Parameters.AddWithValue("@username", UsernameTextBox.Text);
cmd.Parameters.AddWithValue("@password", PasswordTextBox.Text);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "script", "alert('Signup Successfull.. Username is: " + UsernameTextBox.Text + " and Password is: " + PasswordTextBox.Text + "');",true);
ClearControls();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(),"scripts","<script>alert('Signup Failed !!')</script>");
}
}
}
catch (SqlException ex)
{
Response.Write("Exception: " + ex.Message);
}
catch (Exception ex)
{
Response.Write("Exception: " + ex.Message);
}
}
void ClearControls()
{
FirstNameTextBox.Text = LastNameTextBox.Text = EmailTextBox.Text = AddressTextBox.Text = UsernameTextBox.Text = PasswordTextBox.Text = ConfirmPasswordTextBox.Text = "";
DropDownList1.ClearSelection();
}
}
}
Above File is LOGIN_FORM_ASP_PRACTICE\REGISTER.aspx.cs
<?xml version="1.0" encoding="utf-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
https://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<system.web>
<compilation debug="true" targetFramework="4.7.2" />
<httpRuntime targetFramework="4.7.2" />
<pages>
<namespaces>
<add namespace="System.Web.Optimization" />
</namespaces>
<controls>
<add assembly="Microsoft.AspNet.Web.Optimization.WebForms" namespace="Microsoft.AspNet.Web.Optimization.WebForms" tagPrefix="webopt" />
</controls>
</pages>
</system.web>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Antlr3.Runtime" publicKeyToken="eb42632606e9261f" />
<bindingRedirect oldVersion="0.0.0.0-3.5.0.2" newVersion="3.5.0.2" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Web.Infrastructure" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-2.0.0.0" newVersion="2.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" />
<bindingRedirect oldVersion="0.0.0.0-13.0.0.0" newVersion="13.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-1.6.5135.21930" newVersion="1.6.5135.21930" />
</dependentAssembly>
</assemblyBinding>
</runtime>
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701" />
<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:41008 /define:_MYTYPE=\"Web\" /optionInfer+" />
</compilers>
</system.codedom>
<appSettings>
<add key="ValidationSettings:UnobtrusiveValidationMode" value="None"/>
</appSettings>
<connectionStrings>
<add name="dbcs2" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\DotNet\LOGIN_FORM_ASP_PRACTICE\LOGIN_FORM_ASP_PRACTICE\App_Data\MyDatabase.mdf;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>
Above File is Web.config
.png)
.png){kind=small}
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
Comments
Post a Comment