Registration Page Without Encryption and Decryption

<asp:Label ID="Label6" runat="server" Text="Email"></asp:Label>

</td>

<td class="auto-style3">

<asp:TextBox ID="et" runat="server" Width="192px"></asp:TextBox>

</td>

<td class="auto-style3">

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="et" ErrorMessage="Enter valid email address" ForeColor="Red" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

<td class="auto-style6">

<asp:Label ID="Label7" runat="server" Text="Phone:"></asp:Label>

</td>

<td class="auto-style3">

<asp:TextBox ID="pnt" runat="server" Width="192px"></asp:TextBox>

</td>

<td class="auto-style3">

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="pnt" ErrorMessage="Enter a valid US phone number" ForeColor="Red" ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}" Width="230px"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

<td class="auto-style7">

<asp:Label ID="Label8" runat="server" Text="Location"></asp:Label>

</td>

<td class="auto-style8">

<asp:TextBox ID="loct" runat="server" Width="192px"></asp:TextBox>

</td>

<td class="auto-style8">

<asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server" ControlToValidate="loct" ErrorMessage="Enter Correct Zip Code" ForeColor="Red" ValidationExpression="\d{5}(-\d{4})?" Width="230px"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

<td class="auto-style6"> </td>

<td class="auto-style3">&

<br />

<asp:Button ID="Button2" runat="server" Text="Submit" OnClick="Button2_Click" />// submit button

<asp:Button ID="Button3" runat="server" Text="Reset" OnClick="Button3_Click" />// Reset Button

</td>

<td class="auto-style3"> </td>

</tr>

</table>

<br />

<asp:Label ID="lblErrorMsg" runat="server" Text="lblErrorMsg" Visible="False"></asp:Label>

</form>

</body>

</html>

Aspx.cs

using System;

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 WebApplication1

{

public partial class WebForm1 : System.Web.UI.Page

{

private string message = string.Empty;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button2_Click(object sender, EventArgs e) // submit button

{

if (pt.Text == cnfpt.Text)

{

string username = ut.Text;

string password = pt.Text;

string confirmpassword = cnfpt.Text;

string firstname = ft.Text;

string lastname = lt.Text;

string emailaddress = et.Text;

string phone = pnt.Text;

string location = loct.Text;

string createdby = ut.Text;

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=RAJU;Integrated Security=True");

con.Open();

SqlCommand cmd = new SqlCommand("sp_userinformation", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@UserName", username);

cmd.Parameters.AddWithValue("@Password", password);

cmd.Parameters.AddWithValue("@FirstName", firstname);

cmd.Parameters.AddWithValue("@LastName", lastname);

cmd.Parameters.AddWithValue("@Email", emailaddress);

cmd.Parameters.AddWithValue("@PhoneNo", phone);

cmd.Parameters.AddWithValue("@Location", location);

cmd.Parameters.AddWithValue("@Created_By", createdby);

cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);

cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;

cmd.ExecuteNonQuery();

message = (string)cmd.Parameters["@ERROR"].Value;

con.Close();

}

else

{

Page.RegisterStartupScript("UserMsg", "<Script language='javascript'>alert('" + "Password mismatch" + "');</script>");

}

lblErrorMsg.Text = message; // if only user exits already in database then it shows errorlabel as already existed..... initially the label visible was set to false.....

lblErrorMsg.Visible = true;

}

protected void Button3_Click(object sender, EventArgs e)// reset button

{

ut.Text = "";

ft.Text = "";

lt.Text = "";

et.Text = "";

loct.Text ="";

pnt.Text ="";

}

}

}

Backend

First create a User Table in the following format:

Create a Stored Procedure sp_userinfo for inserting values. If the user doesn't exist , else the user exists in other words it must raise an error message. Here I used an output parameter for showing the error:

Create PROCEDURE [dbo].[sp_userinfo]

@UserName varchar(50),

@Password varchar(50),

@FirstName varchar(50),

@LastName varchar(50),

@Email varchar(50),

@PhoneNo varchar(50),

@Location varchar(50),

@Created_By varchar(50),

@ERROR VARCHAR(100) OUT

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

---Checking Condition if User exists or not if user not exists returns different message if exists returns different message

IF NOT EXISTS(SELECT * FROM User WHERE UserName=@UserName)

BEGIN

INSERT INTO User

(

UserName,

[Password],

FirstName,

LastName,

Email,

PhoneNo,

Location,

Created_By

)

VALUES

(

@UserName,

@Password,

@FirstName,

@LastName,

@Email,

@PhoneNo,

@Location,

@Created_By

)

--If User Successfully Registerd I am returing this Message as Output Parameter

SET @ERROR=@UserName+' Registered Successfully'

END

ELSE

BEGIN

--If User already Exists i am returning this Message as Output Parameter

SET @ERROR=@UserName + ' Already Exists'

END

END