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.
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.
12
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
Write below mentioned code in click event of signup button.
C# CODE
VB.NET
Build and run the code.
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.
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.
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 Statement04 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 connection08 SqlConnection con = new SqlConnection(connectionString);09 10 //Create SQL Command And Sql Parameters11 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 try47 {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 finally60 {61 con.Close();62 }63 }VB.NET
01Protected Sub btnSave_Click(sender As Object, e As EventArgs)02 'Create ConnectionString and Inser Statement03 Dim connectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString04 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 connection06 Dim con As New SqlConnection(connectionString)07 08 'Create SQL Command And Sql Parameters09 10 Dim cmd As New SqlCommand()11 cmd.Connection = con12 cmd.CommandType = CommandType.Text13 cmd.CommandText = insertSql14 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 Try45 con.Open()46 cmd.ExecuteNonQuery()47 lblMsg.Text = "User Registration successful"48 Catch ex As SqlException49 Dim errorMessage As String = "Error in registering user"50 errorMessage += ex.Message51 52 Throw New Exception(errorMessage)53 Finally54 con.Close()55 End Try56End SubBuild and run the code.
0 comments:
Post a Comment
Get Benifits