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(userid,name,password,confirmpassword,email,securityquestion,securityanswer) 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(FirstName,LastName,UserName,Password,Address) 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(); }

Simple Registration page with username password and email id screen name

Answers (2)