Display Details of User After Successfull Login

In this article we will learn how to display corresponding details of a user after successful login. In this article we use JavaScript for validation. First we will create a login page where the user will provide their respective credentials, username and password. After successful login the control moves to the details page where all the information of that user is displayed.

Table Creation

Login1.jpg

Now let's move to the code.

Login.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="Login_related_details.Login" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Page</title>

    <script type="text/javascript" language="javascript">

    function Validate()

    {

    var UName=document.getElementById('TextBox_user_name');

    var Password=document.getElementById('TextBox_password');

    if((UName.value=='') || (Password.value==''))

    {

     alert('UserName or Password should not be blank');

     return false;

    }

    else

    {

      return true;

    }

    }

    </script>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <asp:Label ID="lb1" runat="server" Font-Bold="True" ForeColor="#FF3300"></asp:Label><br />

     <asp:Label ID="Label1" runat="server" Text="UserName" Font-Bold="True" Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"></asp:Label>

           

        <asp:TextBox ID="TextBox_user_name" runat="server" ForeColor="#993300" Width="100px"></asp:TextBox><br />

        <asp:Label ID="Label2" runat="server" Text="Password" Font-Bold="True" Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"></asp:Label>

           

        <asp:TextBox ID="TextBox_password" runat="server" ForeColor="#CC6600" TextMode="Password" Width="100px"></asp:TextBox><br />

               

        <asp:Button ID="btn_login" runat="server" Text="Login" Font-Bold="True"

            BackColor="#CCFF99"   OnClientClick="Validate()" onclick="btn_login_Click"

            /><br />

    </div>

    </form>

</body>

</html>

Login.aspx.cs
 

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 Login_related_details

{

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

    {

        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        SqlCommand com;

        SqlDataAdapter sqlda;

        string str;

        DataTable dt;

        int RowCount;

 

        protected void btn_login_Click(object sender, EventArgs e)

        {

            string UserName = TextBox_user_name.Text.Trim();

            string Password = TextBox_password.Text.Trim();

            SqlConnection con = new SqlConnection(strConnString);

            con.Open();

            str = "Select * from Login";

            com = new SqlCommand(str);

            sqlda = new SqlDataAdapter(com.CommandText, con);

            dt = new DataTable();

            sqlda.Fill(dt);

            RowCount = dt.Rows.Count;

            for (int i = 0; i < RowCount; i++)

            {

                UserName = dt.Rows[i]["UserName"].ToString();

                Password = dt.Rows[i]["Password"].ToString();

                if (UserName == TextBox_user_name.Text && Password == TextBox_password.Text)

                {

                    Session["UserName"] = UserName;

                    Response.Redirect("Details.aspx");

                }

                else

                {

                    lb1.Text = "Invalid User Name or Password! Please try again!";

                }

            } 

        }

    }

}

Details.aspx
 

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Details.aspx.cs" Inherits="Login_related_details.Details" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

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

     <h1><font color="olive">User Details</font></h1>

    <table border="1" style="border-collapse: collapse"  cellspacing="1">

    <tr>

      <td width="77" height="16" align="left" ><b><font size="2" color="red">Name:</font></b></td>

      <td width="77" height="16" align="left" ><b><font size="2">&nbsp;<asp:Label

              ID="lbl_UserName" runat="server" Font-Bold="True"></asp:Label><br /></font></b></td>

    </tr>

    <tr>

      <td width="77" height="16" align="left" ><b><font size="2" color="red">Address:</font></b></td>

      <td width="77" height="16" align="left" ><b><font size="2">&nbsp;<asp:Label

              ID="lbl_address" runat="server" Font-Bold="True"></asp:Label><br /></font></b></td>

    </tr>

    <tr>

      <td width="77" height="16" align="left" ><b><font size="2" color="red">Salary:</font></b></td>

      <td width="77" height="16" align="left" ><b><font size="2">&nbsp;<asp:Label

              ID="lbl_sal" runat="server" Font-Bold="True"></asp:Label><br /></font></b></td>

    </tr>

    <tr>

      <td width="77" height="16" align="left" ><b><font size="2" color="red">Phone:</font></b></td>

      <td width="77" height="16" align="left" ><b><font size="2">&nbsp;<asp:Label

              ID="lbl_phone" runat="server" Font-Bold="True"></asp:Label><br /></font></b></td>

    </tr>

    </table>

    </div>

    </form>

</body>

</html>


Details.aspx.cs
 

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 Login_related_details

{

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

    {

        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        string str;

        SqlCommand com;

 

        protected void Page_Load(object sender, EventArgs e)

        {

            lb1.Text = "<b><font color=Brown>" + "WELLCOME:: " + "</font>" + "<b><font color=red>" + Session["UserName"] + "</font>";

            SqlConnection con = new SqlConnection(strConnString);

            con.Open();

            str = "select * from Login where UserName='" + Session["UserName"] + "'";

            com = new SqlCommand(str, con);

            SqlDataAdapter da = new SqlDataAdapter(com);

            DataSet ds = new DataSet();

            da.Fill(ds);

            lbl_UserName.Text = ds.Tables[0].Rows[0]["UserName"].ToString();

            lbl_address.Text = ds.Tables[0].Rows[0]["address"].ToString();

            lbl_sal.Text = ds.Tables[0].Rows[0]["sal"].ToString();

            lbl_phone.Text = ds.Tables[0].Rows[0]["phone"].ToString();

                   

        }

    }

}

Output

Login2.jpg

After providing the correct credentials:

Login3.jpg

 

Next Recommended Readings