ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to create Registration Form in ASP.NET?

Updated on March 5, 2015

To become a member of any website, user has to fill his/her details in the Registration Form. Lets assume that we have a Registration Form as shown below:

First of all we set the following properties:

Field Name
Controls
Properties
First Name
Label
ID: F_Name
 
 
Text: First Name
 
TextBox
ID: FName
 
 
TextMode: SingleLine
 
 
 
Middle Name
Label
ID: M_Name
 
 
Text: Middle Name
 
TextBox
ID: MName
 
 
TextMode: SingleLine
 
 
 
Last Name
Label
ID: L_Name
 
 
Text: Last Name
 
TextBox
ID: LName
 
 
TextMode: SingleLine
 
 
 
Email ID
Label
ID: Email
 
 
Text: Email ID
 
TextBox
ID: EmailID
 
 
TextMode: SingleLine
 
 
 
User Name
Label
ID: User
 
 
Text: User Name
 
TextBox
ID: UserName
 
 
TextMode: SingleLine
 
 
 
Password
Label
ID: Pass
 
 
Text: Password
 
TextBox
ID: Password
 
 
TextMode: Password
 
 
 
Confirm Password
Label
ID: CPass
 
 
Text: Confirm Password
 
TextBox
ID: CPassword
 
 
TextMode: Password
 
 
 
Date of Birth
Label
ID: DOB
 
 
Text: Date of Birth
 
DropDownList
ID: Day
 
 
Items: (Collection)...
 
DropDownList
ID: Month
 
 
Items: (Collection)...
 
DropDownList
ID: Year
 
 
Items: (Collection)...
 
 
 
Gender
Label
ID: Gen
 
 
Text: Gender
 
RadioButtonList
ID: Gender
 
 
Items: (Collection)...
 
 
TextAlign: Right
 
 
 
Address
Label
ID: Addr
 
 
Text: Address
 
TextBox
ID: Address
 
 
TextMode: MultiLine
 
 
 
City
Label
ID: City_Name
 
 
Text: City
 
DropDownList
ID: City
 
 
AutoPostBack: True
 
 
Items: (Collection)...
 
 
 
State
Label
ID: State_Name
 
 
Text: State
 
 
Visible: False
 
DropDownList
ID: State
 
 
Visible: False
 
 
 
Country
Label
ID: Country_Name
 
 
Text: Country
 
 
Visible: False
 
DropDownList
ID: Country
 
 
Visible: False
 
 
 
Pincode
Label
ID: PinNum
 
 
Text: Pincode
 
 
Visible: False
 
TextBox
ID: Pincode
 
 
Visible: False
 
 
 
Mobile No.
Label
ID: Mobile_No
 
 
Text: Mobile No.
 
TextBox
ID: Mobile
 
 
TextMode: SingleLine

Validations to be performed:

  • Field Mark(*) are necessary.
  • First Name, Middle Name and Last Name can contain only alphabets (A-Z or a-z).
  • Pincode and Mobile No. can contain only numbers.
  • Password should be alphanumeric.
  • Password and Confirm Password should be same.
  • Password should be in the range between 8 to 15 characters.

Validators to be used:

  • RequiredFieldValidator
  • CompareValidator
  • RegularExpressionValidator
  • ValidationSummary

Field Name
Validator
Properties
First Name
RequiredFieldValidator
ID: FName_Validator
 
 
ControlToValidate: FName
 
 
Display: None
 
 
ErrorMessage: First Name can't be blank.
 
RegularExpressionValidator
ID: FirstNameValidator
 
 
ControlToValidate: FName
 
 
Display: None
 
 
ErrorMessage: First Name can contain only alphabets.
 
 
ValidationExpression: ^([A-Za-z])+$
Middle Name
RegularExpressionValidator
ID: MName_Validator
 
 
ControlToValidate: MName
 
 
Display: None
 
 
ErrorMessage: Middle Name can contain only alphabets.
 
 
ValidationExpression: ^([A-Za-z])+$
Last Name
RequiredFieldValidator
ID: LName_Validator
 
 
ControlToValidate: LName
 
 
Display: None
 
 
ErrorMessage: Last Name can't be blank.
 
RegularExpressionValidator
ID: LastNameValidator
 
 
ControlToValidate: LName
 
 
Display: None
 
 
ErrorMessage: Last Name can contain only alphabets.
 
 
ValidationExpression: ^([A-Za-z])+$
Email ID
RequiredFieldValidator
ID: EmailValidator
 
 
ControlToValidate: EmailID
 
 
Display: None
 
 
ErrorMessage: Email ID can't be blank.
 
RegularExpressionValidator
ID: EmailID_Validator
 
 
ControlToValidate: EmailID
 
 
Display: None
 
 
ErrorMessage: Please type the valid Email Address.
 
 
ValidationExpression: ^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$
User Name
RequiredFieldValidator
ID: User_Validator
 
 
ControlToValidate: UserName
 
 
Display: None
 
 
ErrorMessage: User Name can't be blank.
Password
RequiredFieldValidator
ID: Pass_Validator
 
 
ControlToValidate: Password
 
 
Display: None
 
 
ErrorMessage: Password can't be blank.
 
RegularExpressionValidator
ID: Password_Validator
 
 
ControlToValidate: Password
 
 
Display: None
 
 
ErrorMessage: Password can't be less than 8 & more than 15 characters.
 
 
ValidationExpression: ^[\w]{8,15}$
 
RegularExpressionValidator
ID: PassValidator
 
 
ControlToValidate: Password
 
 
Display: None
 
 
ErrorMessage: Password is an alphanumeric field.
 
 
ValidationExpression: ^(\w+\d)$
Confirm Password
RequiredFieldValidator
ID: CPass_Validator
 
 
ControlToValidate: CPassword
 
 
Display: None
 
 
ErrorMessage: Please Re-type the Password.
 
CompareValidator
ID: CPassword_Validator
 
 
ControlToCompare: Password
 
 
ControlToValidate: CPassword
 
 
Display: None
 
 
ErrorMessage: The two passwords do not match.
Date of Birth
RequiredFieldValidator
ID: Day_Validator
 
 
ControlToValidate: Day
 
 
Display: None
 
 
ErrorMessage: Please Select Day of Birth.
 
 
InitialValue: 0
 
RequiredFieldValidator
ID: Month_Validator
 
 
ControlToValidate: Month
 
 
Display: None
 
 
ErrorMessage: Please Select Month of Birth
 
 
InitialValue: 0
 
RequiredFieldValidator
ID: Year_Validator
 
 
ControlToValidate: Year
 
 
Display: None
 
 
ErrorMessage: Please Select Year of Birth
 
 
InitialValue: 0
Gender
RequiredFieldValidator
ID: Gender_Validator
 
 
ControlToValidate: Gender
 
 
Display: None
 
 
ErrorMessage: Please Select Gender.
Address
RequiredFieldValidator
ID: Address_Validator
 
 
ControlToValidate: Address
 
 
Display: None
 
 
ErrorMessage: Address can't be blank.
City
RequiredFieldValidator
ID: City_Validator
 
 
ControlToValidate: City
 
 
Display: None
 
 
ErrorMessage: Please Select City
 
 
InitialValue: 0
Pincode
RequiredFieldValidator
ID: Pin_Validator
 
 
ControlToValidate: Pincode
 
 
Display: None
 
 
ErrorMessage: Pincode can't be blank.
 
RegularExpressionValidator
ID: Pincode_Validator
 
 
ControlToValidate: Pincode
 
 
Display: None
 
 
ErrorMessage: Pincode can contain only numbers.
 
 
ValidationExpression: ^([0-9])+$
Mobile No.
RequiredFieldValidator
ID: MobileNum_Validator
 
 
ControlToValidate: Mobile
 
 
Display: None
 
 
ErrorMessage: Mobile No. can't be blank.
 
RegularExpressionValidator
ID: Mobile_Validator
 
 
ControlToValidate: Mobile
 
 
Display: None
 
 
ErrorMessage: Mobile No. can contain only numbers.
 
 
ValidationExpression: ^([0-9])+$
 
 
 
 
ValidationSummary
ID: Summary
 
 
ShowMessageBox: True
 
 
ShowSummary: False

After setting all the properties, create table in Sql Server.

Query

create table User_Registration(
First_Name varchar(15),
Middle_Name varchar(15),
Last_Name varchar(15),
Email_ID varchar(30),
User_Name varchar(25),
Password varchar(15),
Date_of_Birth varchar(10),
Gender varchar(6),
Address varchar(50),
City varchar(15),
State varchar(20),
Country varchar(20),
Pincode varchar(10),
Mobile_No varchar(10),
primary key(User_Name));

Now, add the following code in the codebehind (.cs or .vb) file:

C#

using System.Data;
using System.Data.SqlClient;

public partial class Registration : System.Web.UI.Page
{
 SqlConnection con=new SqlConnection("server = myDB;
 uid = sa; pwd = password; database = master);

protected void City_SelectedIndexChanged(object sender, EventArgs e)
{
 if(Page.IsPostBack)
  {
   Password.Attributes.Add("value",Password.Text);
     //Retain Password Value on PostBack
   CPassword.Attributes.Add("value",CPassword.Text);
     //Retain CPassword Value on PostBack
   Gender.Attributes.Add("value",Gender.SelectedValue);
     //Retain Gender Selected Value on PostBack

    RetrieveCity(City.SelectedItem.Text);
  }
}
protected void Submit_Click(object sender, EventArgs e)
{
  String fieldValues = new String[14];
  fieldValues[0]=FName.Text;
  fieldValues[1]=MName.Text;
  fieldValues[2]=LName.Text;
  fieldValues[3]=EmailID.Text;
  fieldValues[4]=UserName.Text;
  fieldValues[5]=Password.Text;
  fieldValues[6]=Day.SelectedItem.Value+ "-" +Month.SelectedItem.Value+
  "-"+ Year.SelectedItem.Value;
  fieldValues[7]=Gender.SelectedValue;
  fieldValues[8]=Address.Text;
  fieldValues[9]=City.SelectedItem.Value;
  fieldValues[10]=State.SelectedItem.Value;
  fieldValues[11]=Country.SelectedItem.Value;
  fieldValues[12]=Pincode.Text;
  fieldValues[13]=Mobile.Text;

  insertUserDetail("User_Registration",fieldValues);
}
protected void RetrieveCity(String Value)
{
 if(value=="Select")
  {
   State_Name.Visible=false;
   State.Visible=false;
   Country_Name.Visible=false;
   Country.Visible=false;
   PinNum.Visible=false;
   Pincode.Visible=false;
  }
 else
  {
   con.Open();
   SqlCommand com=new SqlCommand("Select State,Country from
   User_Location where City='"+City.SelectedValue+"'",con);
   SqlDataReader dr=com.ExecuteReader();
    while(dr.Read())
     {
       State_Name.Visible=true;
       State.Visible=true;
       Country_Name.Visible=true;
       Country.Visible=true;
       PinNum.Visible=true;
       Pincode.Visible=true;
       State.Items.Add(dr.GetValue(0).ToString();
       State.SelectedValue=dr.GetValue(0).ToString();
        if(State.Items.Count>1)
         {
           State.Items.RemoveAt(0);
           //If user change city value more than once then it will add  
           respective value and remove the previous value.
         }
        if(Country.Items.Count>1)      
         {
           Country.Items.RemoveAt(0);
         }
     }
   dr.Close();
   con.Close();
  }
}
protected void insertUserDetail(String tableName, Array insertArray)
{
  con.Open();
  String strValues="";
   foreach(String strName in insertArray)
    {
      if(strValues.Length==0)
       {
         strValues=strName;
       }
      else
       {
         strValues=strValues+"'"+","+"'"+strName;
       }
    }
     String strInsert="insert into"+tableName+"values(
     '"+ strValues.ToString()+ "')";
     SqlCommand com=new SqlCommand(strInsert,con);  
     com.ExecuteNonQuery();
     Response.Write("<script>alert('Your Registration Is 
     Successful');</script>"); 
}
}

VB

Imports System.Data
Imports System.Data.SqlClient

Partial Public Class Registration
 Inherits System.Web.UI.Page

Dim con As SqlConnection=New SqlConnection("server=myDB;
  uid=sa;pwd=password;database=master")

Protected Sub Submit_Click(ByVal sender As Object,ByVal e As EventArgs)
   Handles Submit.Click

  Dim fieldValues(13) As String
  fieldValues(0)=FName.Text
  fieldValues(1)=MName.Text
  fieldValues(2)=LName.Text
  fieldValues(3)=EmailID.Text
  fieldValues(4)=UserName.Text
  fieldValues(5)=Password.Text
  fieldValues(6)=Day.SelectedItem.Value+ "-"+ Month.SelectedItem.Value+
     "-"+ Year.SelectedItem.Value
  fieldValues(7)=Gender.SelectedValue
  fieldValues(8)=Address.Text
  fieldValues(9)=City.SelectedItem.Value
  fieldValues(10)=State.SelectedItem.Value
  fieldValues(11)=Country.SelectedItem.Value
  fieldValues(12)=Pincode.Text
  fieldValues(13)=Mobile.Text
 
  insertUserDetail("User_Registration",fieldValues)
End Sub

Protected Sub City_SelectedIndexChanged(ByVal sender As Object,ByVal e As EventArgs)Handles City.SelectedIndexChanged

   If Page.IsPostBack Then
     Password.Attributes.Add("value",Password.Text)
        'Retain Password Value on PostBack
     CPassword.Attributes.Add("value",CPassword.Text)
        'Retain CPassword Value on PostBack
     Gender.Attributes.Add("value",Gender.SelectedValue)
        'Retain Gender Selected Value on PostBack

     RetrieveCity(City.SelectedItem.Text)
   End If
   End Sub

Protected Sub RetrieveCity(ByVal value As String)

   If value="Select" Then
    State_Name.Visible=False
    State.Visible=False
    Country_Name.Visible=False
    Country.Visible=False
    PinNum.Visible=False
    Pincode.Visible=False
   Else
    con.Open()
    Dim com As SqlCommand=New SqlCommand("select State,Country from 
    User_Location where City='"+City.SelectedValue+"'",con)
    Dim dr As SqlDataReader=com.ExecuteReader()
     while dr.Read
      State_Name.Visible=True
      State.Visible=True
      Country_Name.Visible=True
      Country.Visible=True
      PinNum.Visible=True
      Pincode.Visible=True
      State.Items.Add(dr.GetValue(0).ToString())
      State.SelectedValue=dr.GetValue(0).ToString()
      Country.Items.Add(dr.GetValue(1).ToString())
      Country.SelectedValue=dr.GetValue(1).ToString()
         If State.Items.Count>1 Then
           State.Items.RemoveAt(0)
         End If
         If Country.Items.Count>1 Then
           Country.Items.RemoveAt(0)
         End If
     End While
    dr.Close()
   End If
    con.Close()
End Sub

Protected Sub insertUserDetail(ByVal tableName As String,
ByVal insertArray As Array)

    con.Open()
    Dim strValues As String=""
    For Each strName As String In insertArray
      If strValues.Length=0 Then
        strValues=strName
      Else
        strValues=strValues+"'"+","+"'"+strName
      End If
    Next
    Dim strInsert As String ="insert into" +
       tableName+"values('"+strValues.ToString()+"')"
    Dim com As SqlCommand=New SqlCommand(strInsert,con)
      com.ExecuteNonQuery()
     Response.Write("<script>alert('Your Registration Is successful');
     </script>")
End Sub
End Class

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      Himanshu 2 years ago

      It is really helpful post

    Click to Rate This Article