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

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Sign_up._Default" %>

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();
            }
        }

    }
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

amit singh13y ago
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 singh13y ago
thanks a lot.
Satyapriya Nayak13y ago
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Sign_up._Default" %>

    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();
            }
        }

    }
}