Simple Registration page with username password and email id screen name

Question

Hi How to create simple registration page with username pwd screen name security question with validation coding

Satyapriya Nayak · Answer

Hi Manuel Try this... Here all types of validation are provided. Untitled Page Create a user account CssClass=style7 Text=Confirm password* /> ValidationExpression=\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*> CssClass=style7 Text=Security question* /> Select CssClass=style7 Text=Security answer* /> ForeColor=#CC3300 onclick=b1_Click /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Create_a_user_account_Csharp { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = select * from secret; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { ddlsecurityquestion.Items.Add(reader[secretqno].ToString()); } reader.Close(); con.Close(); } protected void b1_Click(object sender EventArgs e) { Session[name] = txtname.Text; SqlConnection con = new SqlConnection(connStr); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = insert into useraccount(useridnamepasswordconfirmpasswordemailsecurityquestionsecurityanswer) values(@userid@name@password@confirmpassword@email@securityquestion@securityanswer); com.Parameters.Clear(); com.Parameters.AddWithValue(@userid txtid.Text); com.Parameters.AddWithValue(@name txtname.Text); com.Parameters.AddWithValue(@password txtpassword.Text); com.Parameters.AddWithValue(@confirmpassword txtconfirmpassword.Text); com.Parameters.AddWithValue(@email txtemail.Text); com.Parameters.AddWithValue(@securityquestion ddlsecurityquestion.SelectedValue); com.Parameters.AddWithValue(@securityanswer txtsecurityanswer.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); Response.Redirect(success.aspx); } } } Thanks If this post helps you mark it as answer

Senthilkumar · Answer

Hi Design page: Untitled Page User Registration Form First Name: Last Name: Username: Password: Address: onclick=btnSubmit_Click />   Text=Reset onclick=btnReset_Click /> Code file: protected void Page_Load(object sender EventArgs e) { } protected void btnReset_Click(object sender EventArgs e) { ClearFields(); } private void ClearFields() { txtFirstName.Text = ; txtLastName.Text = ; txtUserName.Text = ; txtPassword.Text = ; txtAddress.Text = ; } protected void btnSubmit_Click(object sender EventArgs e) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = @Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;; sqlConnection.Open(); string sqlQuery = INSERT INTO Users(FirstNameLastNameUserNamePasswordAddress) VALUES(@FirstName@LastName@UserName@Password@Address); SqlCommand sqlCommand = new SqlCommand(sqlQuery sqlConnection); sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.Add(@FirstName SqlDbType.VarChar).Value = txtFirstName.Text.Trim(); sqlCommand.Parameters.Add(@LastName SqlDbType.VarChar).Value = txtLastName.Text.Trim(); sqlCommand.Parameters.Add(@UserName SqlDbType.VarChar).Value = txtUserName.Text.Trim(); sqlCommand.Parameters.Add(@Password SqlDbType.VarChar).Value = txtPassword.Text.Trim(); sqlCommand.Parameters.Add(@Address SqlDbType.VarChar).Value = txtAddress.Text.Trim(); int irows = sqlCommand.ExecuteNonQuery(); lblMessage.Text = User inserted successfully...; ClearFields(); }