Sign Up Page in ASP.NET + MS SQL Database
In this 6th tutorial on dynamic web application development, we will learn how to create a user registration page in ASP.NET. We will create the static user registration page in asp.net & also do its styling using bootstrap framework.
Watch the video tutorial at the end of this video to understand more about how to create master page & apply custom styling. Use the code given below.
Download all Images for this project – CLICK HERE
usersignup.aspx code –
<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="usersignup.aspx.cs" Inherits="WebApplication3.usersignup" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server"></asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="container">
<div class="row">
<div class="col-md-8 mx-auto">
<div class="card">
<div class="card-body">
<div class="row">
<div class="col">
<center>
<img width="100px" src="imgs/generaluser.png"/>
</center>
</div>
</div>
<div class="row">
<div class="col">
<center>
<h4>Member Sign Up</h4>
</center>
</div>
</div>
<div class="row">
<div class="col">
<hr>
</div>
</div>
<div class="row">
<div class="col-md-6">
<label>Full Name</label>
<div class="form-group">
<asp:TextBox CssClass="form-control" ID="TextBox1" runat="server" placeholder="Full Name"></asp:TextBox>
</div>
</div>
<div class="col-md-6">
<label>Date of Birth</label>
<div class="form-group">
<asp:TextBox CssClass="form-control" ID="TextBox2" runat="server" placeholder="Password" TextMode="Date"></asp:TextBox>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<label>Contact No</label>
<div class="form-group">
<asp:TextBox CssClass="form-control" ID="TextBox3" runat="server" placeholder="Contact No" TextMode="Number"></asp:TextBox>
</div>
</div>
<div class="col-md-6">
<label>Email ID</label>
<div class="form-group">
<asp:TextBox CssClass="form-control" ID="TextBox4" runat="server" placeholder="Email ID" TextMode="Email"></asp:TextBox>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<label>State</label>
<div class="form-group">
<asp:DropDownList class="form-control" ID="DropDownList1" runat="server">
<asp:ListItem Text="Select" Value="select" />
<asp:ListItem Text="Andhra Pradesh" Value="Andhra Pradesh" />
<asp:ListItem Text="Arunachal Pradesh" Value="Arunachal Pradesh" />
<asp:ListItem Text="Assam" Value="Assam" />
<asp:ListItem Text="Bihar" Value="Bihar" />
<asp:ListItem Text="Chhattisgarh" Value="Chhattisgarh" />
<asp:ListItem Text="Rajasthan" Value="Rajasthan" />
<asp:ListItem Text="Goa" Value="Goa" />
<asp:ListItem Text="Gujarat" Value="Gujarat" />
<asp:ListItem Text="Haryana" Value="Haryana" />
<asp:ListItem Text="Himachal Pradesh" Value="Himachal Pradesh" />
<asp:ListItem Text="Jammu and Kashmir" Value="Jammu and Kashmir" />
<asp:ListItem Text="Jharkhand" Value="Jharkhand" />
<asp:ListItem Text="Karnataka" Value="Karnataka" />
<asp:ListItem Text="Kerala" Value="Kerala" />
<asp:ListItem Text="Madhya Pradesh" Value="Madhya Pradesh" />
<asp:ListItem Text="Maharashtra" Value="Maharashtra" />
<asp:ListItem Text="Manipur" Value="Manipur" />
<asp:ListItem Text="Meghalaya" Value="Meghalaya" />
<asp:ListItem Text="Mizoram" Value="Mizoram" />
<asp:ListItem Text="Nagaland" Value="Nagaland" />
<asp:ListItem Text="Odisha" Value="Odisha" />
<asp:ListItem Text="Punjab" Value="Punjab" />
<asp:ListItem Text="Rajasthan" Value="Rajasthan" />
<asp:ListItem Text="Sikkim" Value="Sikkim" />
<asp:ListItem Text="Tamil Nadu" Value="Tamil Nadu" />
<asp:ListItem Text="Telangana" Value="Telangana" />
<asp:ListItem Text="Tripura" Value="Tripura" />
<asp:ListItem Text="Uttar Pradesh" Value="Uttar Pradesh" />
<asp:ListItem Text="Uttarakhand" Value="Uttarakhand" />
<asp:ListItem Text="West Bengal" Value="West Bengal" />
</asp:DropDownList>
</div>
</div>
<div class="col-md-4">
<label>City</label>
<div class="form-group">
<asp:TextBox class="form-control" ID="TextBox6" runat="server" placeholder="City"></asp:TextBox>
</div>
</div>
<div class="col-md-4">
<label>Pincode</label>
<div class="form-group">
<asp:TextBox class="form-control" ID="TextBox7" runat="server" placeholder="Pincode" TextMode="Number"></asp:TextBox>
</div>
</div>
</div>
<div class="row">
<div class="col">
<label>Full Address</label>
<div class="form-group">
<asp:TextBox CssClass="form-control" ID="TextBox5" runat="server" placeholder="Full Address" TextMode="MultiLine" Rows="2"></asp:TextBox>
</div>
</div>
</div>
<div class="row">
<div class="col">
<center>
<span class="badge badge-pill badge-info">Login Credentials</span>
</center>
</div>
</div>
<div class="row">
<div class="col-md-6">
<label>Member ID</label>
<div class="form-group">
<asp:TextBox class="form-control" ID="TextBox8" runat="server" placeholder="User ID"></asp:TextBox>
</div>
</div>
<div class="col-md-6">
<label>Password</label>
<div class="form-group">
<asp:TextBox class="form-control" ID="TextBox9" runat="server" placeholder="Email ID" TextMode="Password"></asp:TextBox>
</div>
</div>
</div>
<div class="row">
<div class="col">
<div class="form-group">
<asp:Button class="btn btn-success btn-block btn-lg" ID="Button1" runat="server" Text="Sign Up" OnClick="Button1_Click" />
</div>
</div>
</div>
</div>
</div>
<a href="homepage.aspx"><< Back to Home</a><br><br>
</div>
</div>
</div>
</asp:Content>usersignup.aspx.cs code –
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication3 {
public partial class usersignup: System.Web.UI.Page {
string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
protected void Page_Load(object sender, EventArgs e) {
}
// sign up button click event
protected void Button1_Click(object sender, EventArgs e) {
if (checkMemberExists()) {
Response.Write("<script>alert('Member Already Exist with this Member ID, try other ID');</script>");
} else {
signUpNewMember();
}
}
// user defined method
bool checkMemberExists() {
try {
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed) {
con.Open();
}
SqlCommand cmd = new SqlCommand("SELECT * from member_master_table where member_id='" + TextBox8.Text.Trim() + "';", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count >= 1) {
return true;
} else {
return false;
}
} catch (Exception ex) {
Response.Write("<script>alert('" + ex.Message + "');</script>");
return false;
}
}
void signUpNewMember() {
//Response.Write("<script>alert('Testing');</script>");
try {
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed) {
con.Open();
}
SqlCommand cmd = new SqlCommand("INSERT INTO member_master_table(full_name,dob,contact_no,email,state,city,pincode,full_address,member_id,password,account_status) values(@full_name,@dob,@contact_no,@email,@state,@city,@pincode,@full_address,@member_id,@password,@account_status)", con);
cmd.Parameters.AddWithValue("@full_name", TextBox1.Text.Trim());
cmd.Parameters.AddWithValue("@dob", TextBox2.Text.Trim());
cmd.Parameters.AddWithValue("@contact_no", TextBox3.Text.Trim());
cmd.Parameters.AddWithValue("@email", TextBox4.Text.Trim());
cmd.Parameters.AddWithValue("@state", DropDownList1.SelectedItem.Value);
cmd.Parameters.AddWithValue("@city", TextBox6.Text.Trim());
cmd.Parameters.AddWithValue("@pincode", TextBox7.Text.Trim());
cmd.Parameters.AddWithValue("@full_address", TextBox5.Text.Trim());
cmd.Parameters.AddWithValue("@member_id", TextBox8.Text.Trim());
cmd.Parameters.AddWithValue("@password", TextBox9.Text.Trim());
cmd.Parameters.AddWithValue("@account_status", "pending");
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Sign Up Successful. Go to User Login to Login');</script>");
} catch (Exception ex) {
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
}
}