logout in asp.net

Question

3.00/5 (2 votes)

See more: (untagged)

hi
im doing an asp.net website with a login system for its users. i used a table in sql to maintain a record of user details.when a user logs in , i set a flag to 1 and when they click the logout button , the flag is set back to 0. my problem is if the user closes the browser window or for some reason the system crashes , that user still remains logged in. i have 2 go to the database and set the flag. please suggest some way to solve my prob. thanx

Posted 18-Apr-09 3:49am

nerzhul86

Add a Solution

1 solution

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.

N a v a n e e t h · Answer 1 · 2009-04-18T07:29:00

There are many ways to do this.

1 - Handle the session_end event and reset the DB flag there. This event gets fired when session timed out and will happen even user closes browser (not immediately). Works only on InProc session mode.
2 - Create a new column in table which has the user's last request time. Write a SQL job which runs frequently, checks the last request time and update the flag if necessary.

:)