Create a User Registration Form in ASP.NET using SQL Server, Visual Studio 2022 & Bootstrap

 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="userreg.aspx.cs" Inherits="Registration_Form.userreg" %>


<!DOCTYPE html>


<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>User Registration</title>

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous"/>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz" crossorigin="anonymous"></script>

</head>

<body>

    <div class="container">

        <form class="row g-3 bg-light" runat="server" method="post">

            <div class="bg-primary p-4 rounded mb-3 mt-3">

                <h1 class="text-center text-light">User Registration Form</h1>

            </div>

          <div class="col-md-6">

            <label for="inputEmail4" class="form-label">Email</label>

            <asp:TextBox ID="txtEmail" runat="server" CssClass="form-control"></asp:TextBox>

          </div>

          <div class="col-md-6">

            <label for="inputPassword4" class="form-label">Password</label>

            <asp:TextBox ID="txtPass" runat="server" CssClass="form-control" TextMode="Password"></asp:TextBox>

          </div>

          <div class="col-md-6">

            <label for="inputEmail4" class="form-label">First Name</label>

            <asp:TextBox ID="txtFname" runat="server" CssClass="form-control"></asp:TextBox>

          </div>

          <div class="col-md-6">

            <label for="inputPassword4" class="form-label">Last Name</label>

            <asp:TextBox ID="txtLname" runat="server" CssClass="form-control"></asp:TextBox>

          </div>

          <div class="col-12">

            <label for="inputAddress" class="form-label">Address</label>

            <asp:TextBox ID="txtAddress" runat="server" CssClass="form-control"></asp:TextBox>

          </div>

          <div class="col-md-4">

            <label for="inputCity" class="form-label">Phone</label>

            <asp:TextBox ID="txtPhone" runat="server" CssClass="form-control"></asp:TextBox>

          </div>

          <div class="col-md-4">

            <label for="inputState" class="form-label">Gender</label>

            <asp:DropDownList ID="DropDownList1" runat="server" CssClass="form-select">

                <asp:ListItem Value="male">Male</asp:ListItem>

                <asp:ListItem Value="female">Female</asp:ListItem>

                <asp:ListItem Value="others">Others</asp:ListItem>

            </asp:DropDownList>

          </div>

          <div class="col-md-4">

            <label for="inputZip" class="form-label">DOB</label>

            <asp:TextBox ID="txtDOB" runat="server" TextMode="DateTimeLocal" CssClass="form-control"></asp:TextBox>

          </div>

          <div class="col-12 mb-3">

            <asp:Button ID="Button1" runat="server" CssClass="btn btn-primary" Text="Register" OnClick="Button1_Click"/>

          </div>

        </form>

    </div>

</body>

</html>

ABOVE FILE IS userreg.aspx















using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

namespace Registration_Form
{
    public partial class userreg : System.Web.UI.Page
    {
        string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void EmptyControls()
        {
            txtEmail.Text = "";
            txtPass.Text = "";
            txtFname.Text = "";
            txtLname.Text = "";
            txtAddress.Text = "";
            txtPhone.Text = "";
            DropDownList1.SelectedIndex = -1;
            txtDOB.Text = "";
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (txtEmail.Text == "" || txtPass.Text == "" || txtFname.Text == "" || txtLname.Text == "" || txtAddress.Text == "" || txtPhone.Text == "" || DropDownList1.SelectedIndex == -1 || txtDOB.Text == "")
            {
                Response.Write("<script type='text/javascript'>alert('All fields are required !!')</script>");
            }
            else
            {
                try
                {
                    using (SqlConnection con = new SqlConnection(cs))
                    {
                        con.Open();
                        string query = "INSERT INTO aspuserreg(email,password,fname,lname,address,phone,gender,dob) VALUES(@email,@password,@fname,@lname,@address,@phone,@gender,@dob)";
                        SqlCommand cmd = new SqlCommand(query, con);
                        cmd.Parameters.AddWithValue("@email", txtEmail.Text);
                        cmd.Parameters.AddWithValue("@password", txtPass.Text);
                        cmd.Parameters.AddWithValue("@fname", txtFname.Text);
                        cmd.Parameters.AddWithValue("@lname", txtLname.Text);
                        cmd.Parameters.AddWithValue("@address", txtAddress.Text);
                        cmd.Parameters.AddWithValue("@phone", txtPhone.Text);
                        cmd.Parameters.AddWithValue("@gender", DropDownList1.SelectedItem.ToString());
                        cmd.Parameters.AddWithValue("@dob", Convert.ToDateTime(txtDOB.Text));
                        int a = cmd.ExecuteNonQuery();
                        if (a > 0)
                        {
                            Response.Write("<script type='text/javascript'>alert('Successfully Inserted !!')</script>");
                            EmptyControls();
                        }
                        else
                        {
                            Response.Write("<script>alert('Insertion Failed !!')</script>");
                        }
                    }
                }
                catch (SqlException ex)
                {
                    Response.Write("SqlException : " + ex.Message);
                }
                catch (Exception ex)
                {
                    Response.Write("Exception : " + ex.Message);
                }
            }
        }
    }
}
ABOVE FILE IS userreg.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=\&quot;Web\&quot; /optionInfer+" />
    </compilers>
  </system.codedom>
<connectionStrings>
<add name="dbcs" connectionString="Data Source=DESKTOP-77M6N4G\SQLEXPRESS;Initial Catalog=aspuserreg;Integrated Security=True;TrustServerCertificate=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>
ABOVE FILE IS Web.config














CREATE DATABASE aspuserreg;

USE aspuserreg;

CREATE TABLE aspuserreg(
email VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
fname VARCHAR(50) NOT NULL,
lname VARCHAR(50) NOT NULL,
address VARCHAR(50) NOT NULL,
phone VARCHAR(50) NOT NULL,
gender VARCHAR(50) NOT NULL,
dob DATETIME
);

SELECT * FROM aspuserreg;



Comments

Post a Comment

Popular posts from this blog

Create a Simple Login Form in ASP.NET using Visual Studio 2022

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="login.aspx.cs" Inherits="LoginFormASP.login" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title> </head> <body>     <h1 align="center">Login Form</h1>     <form id="form1" runat="server">         <table align="center">             <tr>                 <td>Username</td>                 <td>                     <asp:TextBox ID="txtUser" runat="server"></asp:TextBox>                 </td>             </tr>             <tr>       ...
Read more

SqlCommand Class ADO.Net | ExecuteNonQuery | ExecuteReader | ExecuteScalar

Image
 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace SQLConnectionADO {     internal class Program     {         static void Main(string[] args)         {             Program.Connection();             Console.ReadLine();         }         static void Connection()         {             string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;             SqlConnection con = null;             try             {                 using (con = new SqlConnection(cs))       ...
Read more