Monday, 1 April 2013

Create User Registration Form In Asp.Net


Create User Registration Form In Asp.Net


Creating User Registration Form Example In Asp.Net

In this post i am explaining how to create user registration or signup page in asp.net with sql server database using C# and VB.NET.

Creating user registration form in asp.net
For this first of all we need to create a table in sql server database to store user registration data.

I have created a table named Users for this example with columns shown in image below.







We can also Create Users with Membership Provider programmatically Or usingCreateUserWizard, You will also need a Login Page

Place textboxes on the form for entering name,username,password,address,email etc.

Set Textmode property of password textbox to password to display * character instead of text entered.

Associate RequiredFieldValidators with textboxes as shown in HTML source.

Place one Label and Button to save the data.

HTML SOURCE OF PAGE
   1:  <table>
   2:  <tr>
   3:  <td>First Name:</td>
   4:  <td><asp:TextBox ID="txtFirstName" runat="server">
   5:     </asp:TextBox>
   6:  </td>
   7:  <td><asp:RequiredFieldValidator ID="rfvFirstName" 
   8:              runat="server" 
   9:              ControlToValidate="txtFirstName"
  10:              ErrorMessage="First Name can't be left blank" 
  11:              SetFocusOnError="True">*
  12:       </asp:RequiredFieldValidator>
  13:  </td>
  14:  </tr>
  15:  <tr>
  16:  <td>Last Name:</td>
  17:  <td><asp:TextBox ID="txtLastName" runat="server">
  18:      </asp:TextBox></td>
  19:  <td><asp:RequiredFieldValidator 
  20:           ID="RequiredFieldValidator1" runat="server" 
  21:           ControlToValidate="txtLastName"
  22:           ErrorMessage="Last Name can't be left blank" 
  23:           SetFocusOnError="True">*
  24:      </asp:RequiredFieldValidator>
  25:  </td></tr>
  26:   
  27:  <tr><td>UserName:</td>
  28:  <td><asp:TextBox ID="txtUserName" runat="server">
  29:      </asp:TextBox>
  30:  </td>
  31:  <td><asp:RequiredFieldValidator 
  32:           ID="rfvUserName" 
  33:           runat="server" 
  34:           ControlToValidate="txtUserName"
  35:           ErrorMessage="UserName can't be left blank" 
  36:           SetFocusOnError="True">*
  37:      </asp:RequiredFieldValidator>
  38:  </td></tr>
  39:   
  40:  <tr><td>Password:</td>
  41:  <td><asp:TextBox ID="txtPwd" runat="server"
  42:                   TextMode="Password">
  43:      </asp:TextBox>
  44:  </td>
  45:  <td><asp:RequiredFieldValidator ID="rfvPwd" 
  46:           runat="server" ControlToValidate="txtPwd"
  47:           ErrorMessage="Password can't be left blank" 
  48:           SetFocusOnError="True">*
  49:     </asp:RequiredFieldValidator>
  50:  </td></tr>
  51:   
  52:  <tr><td>Confirm Password:</td>
  53:  <td><asp:TextBox ID="txtRePwd" runat="server"
  54:                   TextMode="Password">
  55:      </asp:TextBox>
  56:  </td>
  57:  <td><asp:CompareValidator ID="CompareValidator1" 
  58:           runat="server" 
  59:           ControlToCompare="txtRePwd" 
  60:           ControlToValidate="txtPwd" 
  61:           Operator="Equal" 
  62:           ErrorMessage="Password and confirm password do not match" 
  63:           SetFocusOnError="True">
  64:      </asp:CompareValidator>
  65:  </td></tr>
  66:   
  67:  <tr><td>Gender:</td>
  68:  <td><asp:RadioButtonList ID="rdoGender" 
  69:                           runat="server">
  70:           <asp:ListItem>Male</asp:ListItem>
  71:           <asp:ListItem>Female</asp:ListItem>
  72:      </asp:RadioButtonList>
  73:  </td>
  74:  <td><asp:RequiredFieldValidator 
  75:           ID="RequiredFieldValidator2" 
  76:           runat="server" 
  77:           ControlToValidate="rdoGender"
  78:           ErrorMessage="Gender can't be left blank" 
  79:           SetFocusOnError="True">*
  80:       </asp:RequiredFieldValidator>
  81:  </td></tr>
  82:   
  83:  <tr><td>Address:</td>
  84:  <td><asp:TextBox ID="txtAdress" runat="server" 
  85:                   TextMode="MultiLine">
  86:      </asp:TextBox>
  87:  </td>
  88:  <td><asp:RequiredFieldValidator ID="rfvAddress" 
  89:           runat="server" 
  90:           ControlToValidate="txtAdress"
  91:           ErrorMessage="Address can't be left blank" 
  92:           SetFocusOnError="True">*
  93:      </asp:RequiredFieldValidator>
  94:  </td></tr>
  95:                          
  96:  <tr><td>Email ID:</td>
  97:  <td><asp:TextBox ID="txtEmailID" runat="server">
  98:      </asp:TextBox>
  99:  </td>
 100:  <td><asp:RequiredFieldValidator 
 101:           ID="RequiredFieldValidator3" 
 102:           runat="server" 
 103:           ControlToValidate="txtEmailID"
 104:           ErrorMessage="Email can't be left blank" 
 105:           SetFocusOnError="True">*
 106:      </asp:RequiredFieldValidator>
 107:  </td></tr>
 108:   
 109:  <tr><td><asp:Label ID="lblMsg" runat="server">
 110:          </asp:Label>
 111:      </td>
 112:  <td><asp:ValidationSummary ID="ValidationSummary1" 
 113:           runat="server" ShowMessageBox="True" 
 114:           ShowSummary="False"/>
 115:  </td></tr>
 116:   
 117:  <tr><td><asp:Button ID="btnSave" runat="server" 
 118:                      Text="Sign Up" 
 119:                      onclick="btnSave_Click"/>
 120:  </td></tr>
 121:  </table>

Write below mentioned code in click event of signup button.

C# CODE
01protected void btnSave_Click(object sender, EventArgs e)
02    {
03        //Create ConnectionString and Inser Statement
04        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
05        string insertSql = "INSERT INTO Users (FirstName,LastName,UserName,Password,Email,Address,Gender)"
06        + " values (@FirstName,@LastName,@UserName,@Password,@Email,@Address,@Gender)";
07        //Create SQL connection
08        SqlConnection con = new SqlConnection(connectionString);
09 
10        //Create SQL Command And Sql Parameters
11 
12        SqlCommand cmd = new SqlCommand();
13        cmd.Connection = con;
14        cmd.CommandType = CommandType.Text;
15        cmd.CommandText = insertSql;
16 
17        SqlParameter firstName = new SqlParameter("@FirstName", SqlDbType.VarChar, 50);
18        firstName.Value = txtFirstName.Text.ToString();
19        cmd.Parameters.Add(firstName);
20 
21        SqlParameter lastName = new SqlParameter("@LastName", SqlDbType.VarChar, 50);
22        lastName.Value = txtLastName.Text.ToString();
23        cmd.Parameters.Add(lastName);
24 
25        SqlParameter userName = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
26        userName.Value = txtUserName.Text.ToString();
27        cmd.Parameters.Add(userName);
28 
29        SqlParameter pwd = new SqlParameter("@Password", SqlDbType.VarChar, 50);
30        pwd.Value = txtPwd.Text.ToString();
31        cmd.Parameters.Add(pwd);
32 
33        SqlParameter email = new SqlParameter("@Email", SqlDbType.VarChar, 50);
34        email.Value = txtEmailID.Text.ToString();
35        cmd.Parameters.Add(email);
36 
37        SqlParameter address = new SqlParameter("@Address", SqlDbType.VarChar, 50);
38        address.Value = txtAdress.Text.ToString();
39        cmd.Parameters.Add(address);
40 
41        SqlParameter gender = new SqlParameter("@Gender", SqlDbType.VarChar, 10);
42        gender.Value = rdoGender.SelectedItem.ToString();
43        cmd.Parameters.Add(gender);
44 
45 
46        try
47        {
48            con.Open();
49            cmd.ExecuteNonQuery();
50            lblMsg.Text = "User Registration successful";
51        }
52        catch (SqlException ex)
53        {
54            string errorMessage = "Error in registering user";
55            errorMessage += ex.Message;
56            throw new Exception(errorMessage);
57 
58        }
59        finally
60        {
61            con.Close();
62        }
63    }

VB.NET
01Protected Sub btnSave_Click(sender As Object, e As EventArgs)
02 'Create ConnectionString and Inser Statement
03 Dim connectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
04 Dim insertSql As String = "INSERT INTO Users (FirstName,LastName,UserName,Password,Email,Address,Gender)" & " values (@FirstName,@LastName,@UserName,@Password,@Email,@Address,@Gender)"
05 'Create SQL connection
06 Dim con As New SqlConnection(connectionString)
07 
08 'Create SQL Command And Sql Parameters
09 
10 Dim cmd As New SqlCommand()
11 cmd.Connection = con
12 cmd.CommandType = CommandType.Text
13 cmd.CommandText = insertSql
14 
15 Dim firstName As New SqlParameter("@FirstName", SqlDbType.VarChar, 50)
16 firstName.Value = txtFirstName.Text.ToString()
17 cmd.Parameters.Add(firstName)
18 
19 Dim lastName As New SqlParameter("@LastName", SqlDbType.VarChar, 50)
20 lastName.Value = txtLastName.Text.ToString()
21 cmd.Parameters.Add(lastName)
22 
23 Dim userName As New SqlParameter("@UserName", SqlDbType.VarChar, 50)
24 userName.Value = txtUserName.Text.ToString()
25 cmd.Parameters.Add(userName)
26 
27 Dim pwd As New SqlParameter("@Password", SqlDbType.VarChar, 50)
28 pwd.Value = txtPwd.Text.ToString()
29 cmd.Parameters.Add(pwd)
30 
31 Dim email As New SqlParameter("@Email", SqlDbType.VarChar, 50)
32 email.Value = txtEmailID.Text.ToString()
33 cmd.Parameters.Add(email)
34 
35 Dim address As New SqlParameter("@Address", SqlDbType.VarChar, 50)
36 address.Value = txtAdress.Text.ToString()
37 cmd.Parameters.Add(address)
38 
39 Dim gender As New SqlParameter("@Gender", SqlDbType.VarChar, 10)
40 gender.Value = rdoGender.SelectedItem.ToString()
41 cmd.Parameters.Add(gender)
42 
43 
44 Try
45  con.Open()
46  cmd.ExecuteNonQuery()
47  lblMsg.Text = "User Registration successful"
48 Catch ex As SqlException
49  Dim errorMessage As String = "Error in registering user"
50  errorMessage += ex.Message
51 
52  Throw New Exception(errorMessage)
53 Finally
54  con.Close()
55 End Try
56End Sub

Build and run the code.


Download Sample Code

No comments:

Post a Comment