Login Form in ASP.Net with C#

Here, I’m going to describe Login web Form in ASP.Net. This article’s beauties are, it provide login for Admin and User both from single table according define role. This demo is having proper validation and Stay login. Steps are given below:

Step 1:- Create a table and fill records

CREATE TABLE LoginAuthentication

(

[id] [varchar](50) Primary Key,

[pass] [varchar](50) NOT NULL,

[role] [int] NOT NULL

)

Note:- Here role 1 means Admin Login and 0 means User Login

Step 2: Take three web pages namely “Login.aspx”, “Admin.aspx” and “User.aspx”

Step 3:- Add Connection String in web.config file

<add name="dbconnection" providerName="System.Data.SqlClient"

connectionString="Data Source=.;Initial Catalog=avi;User Id=avisqlserver; password=123456" />

</connectionStrings>

</configuration>

Step 4:- Login.aspx

.style1

{

width: 75px;

}

.style2

{

width: 417px;

}

</style>

window.history.forward();

function noBack() { window.history.forward(1); }

</script>

<%--RequerFeildValidater--%>

function ValidateFeild() {

var txtId = document.getElementById("txtId").value;

var txtPass = document.getElementById("txtPassword").value;

if (txtId === "") {

document.getElementById("lblId").innerHTML = "*";

document.getElementById("lblId").title = "Enter email id";

return false;

}

else {

document.getElementById("lblId").innerHTML = "";

}

if (txtPass === "") {

document.getElementById("lblPass").innerHTML = "*";

document.getElementById("lblPass").title = "Enter password";

return false;

}

else {

document.getElementById("lblPass").innerHTML = "";

}

if (txtId !== "") {

var RegExEmail = /^(?:\w+\.?)*\w+@(?:\w+\.)+\w+$/;

if (!RegExEmail.test(txtId)) {

document.getElementById("lblEmailValid").innerHTML = "*";

document.getElementById("lblEmailValid").title = "Email formate incorrect";

return false;

}

else {

document.getElementById("lblEmailValid").innerHTML = "";

}

</script>

</head>

</td>

</td>

</tr>

<tr>

Email Id

</td>

<asp:TextBox ID="txtId" runat="server" Width="130px"meta:resourcekey="txtIdResource1" OnFocus="this.style.borderColor='blue'"OnBlur="this.style.borderColor=''" ></asp:TextBox>

<asp:Label ID="lblId" runat="server" ForeColor="#FF3300"></asp:Label>

<asp:Label ID="lblEmailValid" runat="server" ForeColor="#FF3300"></asp:Label>

</td>

</tr>

<tr>

<asp:Label ID="lblPassword" runat="server" Text="Password"meta:resourcekey="lblPasswordResource1"></asp:Label>

</td>

<asp:TextBox ID="txtPassword" runat="server" Width="130px"meta:resourcekey="txtPasswordResource1" OnFocus="this.style.borderColor='blue'"OnBlur="this.style.borderColor=''"

TextMode="Password"></asp:TextBox>

<asp:Label ID="lblPass" runat="server" ForeColor="#FF3300"></asp:Label>

</td>

</tr>

<tr>

<td>

</td>

<asp:Label ID="lblErrorMsg" runat="server" ForeColor="#FF3300"Visible="False" meta:resourcekey="lblErrorMsgResource1"></asp:Label>

</td>

</tr>

<tr>

<td>

</td>

<td>

<asp:CheckBox ID="chkRemember" runat="server" Text="Stay signed in" />

</td>

</tr>

<tr>

</td>

<asp:Button ID="btnLogin" runat="server" Text="Sign In"OnClientClick="return ValidateFeild(this)"

OnClick="btnLogin_Click1" meta:resourcekey="btnLoginResource1" />

</td>

</tr>

</table>

</fieldset>

</div>

</form>

</body>

</html>

Output

Step 5:- Login.aspx.cs

using System;

using System.Data;

using System.Data.SqlClient;

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

{

readonly string cnString = System.Configuration.ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;

public void login(string id, string pass)

{

if (id.Length > 0 && pass.Length > 0)

{

try

{

SqlConnection con = new SqlConnection(cnString);

SqlCommand cmd = new SqlCommand(String.Format("select * from LoginAuthentication where id = '{0}'", id), con);

if (con.State == ConnectionState.Closed)

con.Open();

using (SqlDataReader rd = cmd.ExecuteReader())

{

if (rd.Read())

{

if (rd["pass"].ToString() == pass)

{

lblErrorMsg.Visible = false;

if (chkRemember.Checked == true)

{

Response.Cookies["IdCookie"].Value = txtId.Text.Trim();

Response.Cookies["IdCookie"].Expires =DateTime.Now.AddDays(30);

Response.Cookies["PassCookie"].Value = txtPassword.Text.Trim();

Response.Cookies["PassCookie"].Expires =DateTime.Now.AddDays(30);

}

if (Convert.ToInt32(rd["role"]) == 1)

{

Session.Add("AdminSession", id);

Response.Redirect("Admin.aspx");

}

else

{

Session.Add("UserSession", id);

Response.Redirect("User.aspx");

}

else

{

lblErrorMsg.Text = "password incorrect";

lblErrorMsg.Visible = true;

}

else

{

lblErrorMsg.Text = "email id incorrect ";

lblErrorMsg.Visible = true;

}

if (con.State == ConnectionState.Open)

con.Close();

}

catch

{

}

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

if (Request.Cookies["IdCookie"] != null && Request.Cookies["PassCookie"] != null)

}

protected void btnLogin_Click1(object sender, EventArgs e)

{

}

Step 6:- Admin.aspx

window.history.forward();

function noBack() { window.history.forward(1); }

</script>

</head>

<div>

Welcome Admin Panel

<asp:LinkButton ID="LinkButton1" runat="server"

style="float: right; margin:0px 40px 0px 0px" onclick="LinkButton1_Click">Sign Out</asp:LinkButton>

</div>

</form>

</body>

</html>

Step 7:- Admin.aspx.cs

using System;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (Convert.ToString(Session["AdminSession"]) == "")

Response.Redirect("Login.aspx");

}

protected void LinkButton1_Click(object sender, EventArgs e)

{

Session.Abandon();

Response.Cookies["IdCookie"].Value = null;

Response.Cookies["PassCookie"].Value = null;

Response.Redirect("Login.aspx");

}

Step 8:- User.aspx

window.history.forward();

function noBack() { window.history.forward(1); }

</script>

</head>

<div>

Welcome User Panel

<asp:LinkButton ID="LinkButton1" runat="server"

style="float: right; margin:0px 40px 0px 0px" onclick="LinkButton1_Click">Sign Out</asp:LinkButton>

</div>

</form>

</body>

</html>

Step 9:- User.aspx.cs

using System;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (Convert.ToString(Session["UserSession"]) == "")

Response.Redirect("Login.aspx");

}

protected void LinkButton1_Click(object sender, EventArgs e)

{

Session.Abandon();

Response.Cookies["IdCookie"].Value = null;

Response.Cookies["PassCookie"].Value = null;

Response.Redirect("Login.aspx");

}

Step 10:- compile the program and run the application

Note- If you not properly Sing Out web form then, when will be open Login web form, automatic previous Logged web form open, because cookies are set on Admin and User web form’s Page_Load event.

Comments