Hello All, We are going to start new batch from next week. message/call or mail us for more details.

4 July 2012

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    }
Build and run the code.

2 comments:

  1. Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
    Advanced AWS Training in Bangalore | Best Amazon Web Services Training Institute in Bangalore
    Advanced AWS Training Institute in Pune | Best Amazon Web Services Training Institute in Pune
    Advanced AWS Online Training Institute in india | Best Online AWS Certification Course in india
    AWS training in bangalore | Best aws training in bangalore

    ReplyDelete