.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> ASP.NET >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Display details of user after successfull login

Posted By:satyapriyanayak       Posted Date: November 21, 2013    Points: 200    Category: ASP.NET    URL: http://www.dotnetspark.com  

In this article we will know how to display corresponding details of user after successful login. Here we use JavaScript for validation. First we will create a login page where user will provide their respective credential(username and password).After successful login the control moves to details page where all information of that user are displayed.
 

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


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend