How to Check which user is login on masterpage Lable text

Question

0.00/5 (No votes)

See more:

Hello Developers,

I want to know on my website Home page, which user is login in his account. If anyone will be login, then his Username will be displayed on my website home page in his system. and if no one is login, then "Welcome Guest" will be displayed.

Please give me solution for this,
I already try it with
1. By use of session

if (Session["client_username"] == null)
{
lbl_user.Text = "Welcome Guest";
}
else
{
lbl_user.Text = username.ToString();

}

use of session, it is not working, it always show "Welcome Guest"

2 select form database table according to field of "IsLogin" status.

DataSet ds = c_client_login.status(Session["client_username"].ToString(), 1);
if (ds.Tables[0].Rows[0]["IsLogin"].ToString() != "1";)
{

lbl_user.Text = "Welcome Guest";

//txt_pric.Text = ds.Tables[0].Rows[0]["total_price"].ToString() + "/-";
}
else
{
lbl_user.Text = Session["client_username"].ToString();
//txt_pric.Text = "0/-";
}

2 way, it display and error of" Object reference not set to an instance

please give me a perfect solution

Posted 22-Mar-14 7:44am

Neeraj_kaushik

Add a Solution

Comments

CoderPanda 22-Mar-14 13:51pm

Where are you fetching the the user's name from the DB and assigning to Session["client_username"] ?

Neeraj_kaushik 22-Mar-14 14:00pm

this code is placed on Master page, and also here i am fetching Username which Login stause is "1" according

Neeraj_kaushik 22-Mar-14 14:01pm

c_client_login.status(Session["client_username"].ToString(), 1);

this line call the "status" function of " c_client_login table" and i fetch the username in class

public static DataSet status(string user_session, int IsLogin)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ToString();
// eshop_connection con = new eshop_connection();
SqlDataAdapter da = new SqlDataAdapter("select * from client_login where client_user_name=@client_user_name",con);
con.Open();
da.SelectCommand.Parameters.AddWithValue("@client_user_name", user_session);
da.SelectCommand.Parameters.AddWithValue("@IsLogin", IsLogin);

DataSet ds = new DataSet();
da.Fill(ds);
con.Close();

return ds;
}

Neeraj_kaushik 22-Mar-14 14:04pm

My login page coding for get username

DataTable dt = c_client_login._GetBy_login(txt_unm.Text, txt_psd.Text);

if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[0]["client_user_name"].ToString() == txt_unm.Text.Trim() && dt.Rows[0]["password"].ToString() == txt_psd.Text.Trim())
{

Session["client_username"] = dt.Rows[0]["client_user_name"].ToString();
Session["client_code"] = dt.Rows[0]["client_code"].ToString();
//Session["client_ip"] = txt_ip.Text;
c_client_login._upagteBy_login(Session["client_username"].ToString(),1);

Response.Redirect("~/Client/Home.aspx");

}
else
{
Label3.Visible = true;
Label3.Text = "Login Info Is Not Correct";
}

CoderPanda 22-Mar-14 14:26pm

Okay, can you please check if somehow nothing is being returned from DB in the following line?
Session["client_username"] = dt.Rows[0]["client_user_name"].ToString();
If it is getting something from DB, then is there any other place in the code where Session["client_username"] is being overwritten?

Neeraj_kaushik 22-Mar-14 14:32pm

i get username from database, if username is correct, then it will be redirect to Home page otherwise it i display an error .
and
can you explain overwritten,
this session is create only Login page not anywhere.

can you send me a complete code with classes and stored procedure to check username for login and display username on Master page

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2014-03-22T08:18:00

Solution 1

You just need to set the session variable. However you are logging them in set Session["client_username"] = someVariable; Then you can use it wherever you need it.

Posted 22-Mar-14 8:18am

ZurdoDev

Comments

Neeraj_kaushik 22-Mar-14 14:21pm

Please Read my last comment
or see here

My login page coding for get username

DataTable dt = c_client_login._GetBy_login(txt_unm.Text, txt_psd.Text);

if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[0]["client_user_name"].ToString() == txt_unm.Text.Trim() && dt.Rows[0]["password"].ToString() == txt_psd.Text.Trim())
{

Session["client_username"] = dt.Rows[0]["client_user_name"].ToString();
Session["client_code"] = dt.Rows[0]["client_code"].ToString();
//Session["client_ip"] = txt_ip.Text;
c_client_login._upagteBy_login(Session["client_username"].ToString(),1);

Response.Redirect("~/Client/Home.aspx");

}
else
{
Label3.Visible = true;
Label3.Text = "Login Info Is Not Correct";
}

and on Masterpage

if (Session["client_username"] == null)
{
lbl_user.Text = "Welcome Guest";
}
else
{
lbl_user.Text = username.ToString();

}

use of session, it is not working, it always show "Welcome Guest"

2 select form database table according to field of "IsLogin" status.

DataSet ds = c_client_login.status(Session["client_username"].ToString(), 1);
if (ds.Tables[0].Rows[0]["IsLogin"].ToString() != "1";)
{

lbl_user.Text = "Welcome Guest";

//txt_pric.Text = ds.Tables[0].Rows[0]["total_price"].ToString() + "/-";
}
else
{
lbl_user.Text = Session["client_username"].ToString();
//txt_pric.Text = "0/-";
}

2 way, it display and error of" Object reference not set to an instance

ZurdoDev 22-Mar-14 14:27pm

This is a timing issue. All you need to do is put breakpoints and you'll see that your master page runs first, before you have filled it in. You need use a different event if you want it in the master page, perhaps onprerender.

Neeraj_kaushik 22-Mar-14 14:37pm

i don't use onprerender before.
you can explain working of my query here,
try to understand your answer

ZurdoDev 22-Mar-14 15:43pm

Refer to this link for the order of events of content pages and master pages.
http://msdn.microsoft.com/en-us/library/dct97kc3.ASPX

**Nirav Prabtani** · Answer 2 · 2014-03-22T08:37:00

Solution 2

Just enter userID in to session during login like this.. :)

C#

Session["user"]= 5;

You can got it Any where in application till it will not expired like

C#

lblSession.Text=Session["user"].toString();

Set session timeout like this

C#

<configuration>
  <system.web>
     <sessionState timeout="20"></sessionState>
  </system.web>
</configuration>

Posted 22-Mar-14 8:37am

Nirav Prabtani

Updated 22-Mar-14 9:51am

v2

Comments

Neeraj_kaushik 22-Mar-14 14:41pm

i already try on masterpage.
lblSession.Text=Session["user"].toString();

but it is not working and sometime it will display error of "Object reference not set to
an inistance"

Nirav Prabtani 22-Mar-14 14:48pm

It gives error when session expires ...set session timing in web.config and convert it into string like that Convert.ToString() instead .ToString()

Neeraj_kaushik 22-Mar-14 14:52pm

see my config file

<configuration>
<system.web>
<compilation debug="true" targetframework="4.0">

<trust level="Full" />
<httpruntime maxrequestlength="1048576"
="" executiontimeout="15000">

<customerrors mode="Off">

<pages enableEventValidation="true"/>


<sessionstate
="" mode="InProc" cookieless="true" timeout="1500" regenerateexpiredsessionid="true">

Nirav Prabtani 22-Mar-14 14:59pm

Neeraj_kaushik 22-Mar-14 15:02pm

??

Nirav Prabtani 22-Mar-14 15:00pm

No, Paste it

<configuration>
<system.web>
<sessionstate timeout="20">

Neeraj_kaushik 22-Mar-14 15:02pm

what ?

Nirav Prabtani 22-Mar-14 15:49pm

Nirav Prabtani 22-Mar-14 15:50pm

sorry I can not post code here

Nirav Prabtani 22-Mar-14 15:50pm

My code is in above solution