how to find out that wether the login person is active or not

Question

3.50/5 (2 votes)

See more:

hi

i am facing a problem with the active user and inactive user, in my web application that when user login i am changing the status as 1 in database,and when user logout, then iam changing the status as 0 in database
upto now every thing is fine ,

when the user exits the browsers without loging out, then how can i find this type of user to chage the status as 0 in database

is there any idea to change the status in the database , generally in this type of situations what the programers should do

so please give me an idea.

thanks in advance

Posted 19-Jan-12 0:23am

sivakumarmr10

Add a Solution

Comments

BobJanova 19-Jan-12 12:02pm

Short answer: don't do this, it's almost always bad design.

[no name] 24-Jan-12 5:14am

Mr.BobJanova nice replay,................

thankq for your replay

3 solutions

Solution 1

You can update database on pageunload event,

and you can also use trigger to update the database after specific interval of time (for eg 1 hour,1 day etc) on the base of session

Posted 19-Jan-12 0:38am

Syed Salman Raza Zaidi

Comments

RDBurmon 19-Jan-12 6:39am

My +5

manognya kota 19-Jan-12 8:43am

Good answer +5

Solution 3

hello,

you can get the session_end() event in global.asax.
on that event you can write code to set zero in database.

Posted 19-Jan-12 20:53pm

amolpatil2243

Comments

bbirajdar 24-Jan-12 5:42am

Closing the browser window, or browsing to another site will NOT cause Session_End to fire, at least, not straightaway - the server has absolutely no way of knowing what happens on the client machine until it gets another HttpRequest from it. In this instance, Session_End will fire when the session times out naturally.

amolpatil2243 24-Jan-12 6:19am

thanks for update

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)

bbirajdar · Accepted Answer · 2012-01-19T01:55:00

Here is a asp.net control that fires a server side callback event on browser close. Use this one

http://www.aspfr.com/codes/ASP-NET-SAVOIR-QUAND-UTILISATEUR-FERME-FENETRE-VIA_53700.aspx[^]

Other links that you can use are

How to end user session when browser closed[^]

destroy session and logout a user when browser window is closed instead of clicking logout button[^]

Force log off on browser exit[^]

How to run server side function when user close the browser (not refresh)?[^]

how to find out that wether the login person is active or not

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us