Simple Registration form in Asp.Net with validations
SIMPLE REGISTRATION FORM IN ASP.NET WITH C#.NET and VB.NET
In this article we will see a simple registration form in asp.net with all client side validations. I am designing a registration form with fields like first name, last name, email, etc,.. and inserting the data into database using insert sql statement .
Here I am adding a local database to my asp.net application and using the local database. The connection string is taken in web.config file. You can download the source code from the link provided below.
Create table in sql server
I am designing the aspx page as follows
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 |
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserRegistration.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <style type="text/css"> .style4 { width: 212px; } .style7 { width: 212px; height: 31px; } .style9 { height: 26px; } .style11 { width: 259px; } .style12 { width: 259px; height: 31px; } </style> </head> <body> <form id="form1" runat="server"> <div> <table style="border: 1pt solid #6666FF; width: 60%; height: 424px; font-family: Verdana; border-collapse: collapse; background-color: #ffffff;" align="center"> <tr> <td align="center" colspan="3" class="style9"> <asp:Label ID="lblHeader" runat="server" Text="Registration Form" Font-Bold="True"></asp:Label> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblFirstName" runat="server" Text="First Name :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvFirstName" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="txtFirstName"></asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblLastName" runat="server" Text="Last Name :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvLastName" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="txtLastName"></asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblEmail" runat="server" Text="E-Mail :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvUserName" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="txtEmail"></asp:RequiredFieldValidator> <br /> <asp:RegularExpressionValidator ID="RxvEmail" runat="server" ControlToValidate="txtEmail" ErrorMessage="Invalid E-mail" ForeColor="#FF3300" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblPassword" runat="server" Text="Password :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtPassword" runat="server" TextMode="Password"></asp:TextBox> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvPwd" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="txtPassword"></asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblConfirmPwd" runat="server" Text="Confirm Pasword :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtConfirmPwd" runat="server" TextMode="Password"></asp:TextBox> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvCnfrmPwd" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="txtConfirmPwd"></asp:RequiredFieldValidator> <br /> <asp:CompareValidator ID="CvCnfmPwd" runat="server" ErrorMessage="Password and Confirm Password didnt matched" ForeColor="#FF3300" ControlToCompare="txtPassword" ControlToValidate="txtConfirmPwd"></asp:CompareValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblGender" runat="server" Text="Gender :"></asp:Label> </td> <td class="style11" align="left"> <asp:RadioButtonList ID="RdoGender" runat="server" RepeatDirection="Horizontal" Width="176px"> <asp:ListItem>Male</asp:ListItem> <asp:ListItem>Female</asp:ListItem> </asp:RadioButtonList> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvGender" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="RdoGender"></asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblDob" runat="server" Text="Date of Birth :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtDob" runat="server"></asp:TextBox> <asp:Label ID="Label1" runat="server" Text="(dd/mm/yyyy)"></asp:Label> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="* Required" ForeColor="#FF3300" ControlToValidate="txtDob"></asp:RequiredFieldValidator> <br /> <asp:RegularExpressionValidator ID="RxvDob" runat="server" ControlToValidate="txtDob" ErrorMessage="Invalid Date Format" ValidationExpression="^(((((0[1-9])|(1\d)|(2[0-8]))\/((0[1-9])|(1[0-2])))|((31\/((0[13578])|(1[02])))|((29|30)\/((0[1,3-9])|(1[0-2])))))\/((20[0-9][0-9])|(19[0-9][0-9])))|((29\/02\/(19|20)(([02468][048])|([13579][26]))))$" ForeColor="#FF3300"></asp:RegularExpressionValidator> </td> </tr> <tr> <td align="right" class="style11"> <asp:Label ID="lblMobile" runat="server" Text="Mobile"></asp:Label> </td> <td class="style11"> <asp:TextBox ID="txtMobile" runat="server" MaxLength="10"></asp:TextBox> </td> <td class="style4"> <asp:RegularExpressionValidator ID="RxvMobile" runat="server" ErrorMessage="Invalid Mobile Number" ForeColor="#FF3300" ValidationExpression="^([7-9]{1})([0-9]{9})$" ControlToValidate="txtMobile"></asp:RegularExpressionValidator> </td> </tr> <tr> <td class="style11" align="right"> <asp:Label ID="lblAddress" runat="server" Text="Address :"></asp:Label> </td> <td class="style11" align="left"> <asp:TextBox ID="txtAddress" runat="server" TextMode="MultiLine"></asp:TextBox> </td> <td class="style4" align="left"> <asp:RequiredFieldValidator ID="RfvAddress" runat="server" ErrorMessage="* Required" ForeColor="Red" ControlToValidate="txtAddress"></asp:RequiredFieldValidator> </td> </tr> <td align="center" class="style12"> <asp:Label ID="lblMsg" runat="server" ForeColor="#CC3300"></asp:Label> </td> <td class="style12"> <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" /> <asp:Button ID="btnClear" runat="server" CausesValidation="False" OnClick="btnClear_Click" Text="Clear" /> </td> <td align="center" class="style7"> </td> </tr> </table> </div> </form> </body> </html> |
The c# code in the code behind file is given below :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
using System; using System.Web.UI; using System.Data.SqlClient; using System.Configuration; using System.Data; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } //declaring connection string and command //here we are extracting connection string from web.config file SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ToString()); SqlCommand cmd = new SqlCommand(); protected void btnSubmit_Click(object sender, EventArgs e) { try { cmd.Connection = con; //assigning connection to command cmd.CommandType = CommandType.Text; //representing type of command //cmd.CommandText = "INSERT INTO UserDetails (Fname,Lname,Email,Password,Gender,Dob,Mobile,Address) values // (@Fname,@Lname,@Email,@Password,@Gender,@Dob,@Mobile,@Address)"; cmd.CommandText = "INSERT INTO UserDetails values(@Fname,@Lname,@Email,@Password,@Gender,@Dob,@Mobile,@Address)"; //adding parameters with value cmd.Parameters.AddWithValue("@Fname", txtFirstName.Text.ToString()); cmd.Parameters.AddWithValue("@Lname", txtLastName.Text.ToString()); cmd.Parameters.AddWithValue("@Email",txtEmail.Text.ToString()); cmd.Parameters.AddWithValue("@Password",txtPassword.Text.ToString()); cmd.Parameters.AddWithValue("@Gender",RdoGender.SelectedItem.Text.ToString()); cmd.Parameters.AddWithValue("@Dob",txtDob.Text.ToString()); cmd.Parameters.AddWithValue("@Mobile",txtMobile.Text.ToString()); cmd.Parameters.AddWithValue("@Address",txtAddress.Text.ToString()); con.Open(); //opening connection cmd.ExecuteNonQuery(); //executing query con.Close(); //closing connection lblMsg.Text="Registered Successfully.."; } catch(Exception ex) { lblMsg.Text=ex.Message.ToString(); } } protected void btnClear_Click(object sender, EventArgs e) { //refreshing/reloading page to clear all the controls Page.Response.Redirect(Page.Request.Url.ToString(), true); } } |
The VB.net code in the code behind file is given below :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
Imports System.Web.UI Imports System.Data.SqlClient Imports System.Configuration Imports System.Data Partial Class Registration_Vb Inherits System.Web.UI.Page 'declaring connection string and command 'here we are extracting connection string from web.config file Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("MyConnection").ToString()) Private cmd As New SqlCommand() Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Try cmd.Connection = con 'assigning connection to command cmd.CommandType = CommandType.Text 'representing type of command 'cmd.CommandText = "INSERT INTO UserDetails (Fname,Lname,Email,Password,Gender,Dob,Mobile,Address) values ' (@Fname,@Lname,@Email,@Password,@Gender,@Dob,@Mobile,@Address)"; cmd.CommandText = "INSERT INTO UserDetails values(@Fname,@Lname,@Email,@Password,@Gender,@Dob,@Mobile,@Address)" 'adding parameters with value cmd.Parameters.AddWithValue("@Fname", txtFirstName.Text.ToString()) cmd.Parameters.AddWithValue("@Lname", txtLastName.Text.ToString()) cmd.Parameters.AddWithValue("@Email", txtEmail.Text.ToString()) cmd.Parameters.AddWithValue("@Password", txtPassword.Text.ToString()) cmd.Parameters.AddWithValue("@Gender", RdoGender.SelectedItem.Text.ToString()) cmd.Parameters.AddWithValue("@Dob", txtDob.Text.ToString()) cmd.Parameters.AddWithValue("@Mobile", txtMobile.Text.ToString()) cmd.Parameters.AddWithValue("@Address", txtAddress.Text.ToString()) con.Open() 'opening connection cmd.ExecuteNonQuery() 'executing query con.Close() 'closing connection lblMsg.Text = "Registered Successfully.." Catch ex As Exception lblMsg.Text = ex.Message.ToString() End Try End Sub Protected Sub btnClear_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnClear.Click 'refreshing/reloading page to clear all the controls Page.Response.Redirect(Page.Request.Url.ToString(), True) End Sub End Class |
Posts you may like :
