C# signup form code with validation using back-end sqlserver

Question

i have label User-idfirst-namelast-namepassword secrete answer and two radio button male and female with one submit and exit button . please give me accurate answer so that i can understand...

Satyapriya Nayak · Answer

Untitled Page ControlToValidate=txt_userid ErrorMessage=userid required> ControlToValidate=txt_firstname ErrorMessage=firstname required> ControlToValidate=txt_lastname ErrorMessage=lastname required> ControlToValidate=txt_password ErrorMessage=password required> ControlToValidate=txt_secreateanswer ErrorMessage=secreteanswer required> onclick=btn_register_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 Sign_up { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; protected void btn_register_Click(object sender EventArgs e) { if (rb1.Checked == true) { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = insert into register values(@userid@firstname@lastname@password@secreteanswer@gender); com.Parameters.Clear(); com.Parameters.AddWithValue(@userid txt_userid.Text); com.Parameters.AddWithValue(@firstname txt_firstname.Text); com.Parameters.AddWithValue(@lastname txt_lastname.Text); com.Parameters.AddWithValue(@password txt_password.Text); com.Parameters.AddWithValue(@secreteanswer txt_secreateanswer.Text); com.Parameters.AddWithValue(@gender rb1.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = Data entered successfully!!!; //clear(); } else { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = insert into register values(@userid@firstname@lastname@password@secreteanswer@gender); com.Parameters.Clear(); com.Parameters.AddWithValue(@userid txt_userid.Text); com.Parameters.AddWithValue(@firstname txt_firstname.Text); com.Parameters.AddWithValue(@lastname txt_lastname.Text); com.Parameters.AddWithValue(@password txt_password.Text); com.Parameters.AddWithValue(@secreteanswer txt_secreateanswer.Text); com.Parameters.AddWithValue(@gender rb2.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = Data entered successfully!!!; //clear(); } } } }

amit singh · Answer

i am doing project in C# with back end sqlserver 2005 .my project is steganography .i have facing problem while creating signup form and sign in also it's validation.pls. check this code and reply with solution if possible

amit singh · Answer

thanks a lot.