How to tackle this session problem?

Question

I have a question regarding storing the status of user. The following requirement are there: When authorized user logs into the system.he/she is not allowed to login from another computer or in different browser other than he is using right this time.- Remedy we applied here as : We have kept  Is_Loggedin  as a column with data type  bit  in a mst_vendor as a table name. when a user logs in we set the flag to Is_Loggedin as  1  and each time when someone tries to log in using this accountthe system is showing the error  The user is already logged in  When he logs out it turns to  0  as logout procedure calls as soon as he clicks log out button. Problem scenario: 1.When user closes the browser the flag remains the same i.e  1  2.When power gets offIt remains the same as  1  3.If session timeouts after a predefined value it remains the same. 4.There may be different scenarios other than this. Is there any way so that we can store this internal flagging for user's login status using application object. It may improve efficiency of the system and also eliminates the above problematic scenarios .

Crish · Answer

hi set session state in web.config for solution of session problem in asp.net.

Manikavelu Velayutham · Answer

1.When user closes the browser the flag remains the same i.e  1  - You have to call the function that will change the flag in OnUnload event of the body tag of the page. 2.When power gets offIt remains the same as  1  - You have to create the job in sql server that could run every 10 or 20 minutes based on your need to update the flag in the database. 3.If session timeouts after a predefined value it remains the same. - You have to handle the session_end event in the global.asax page. If you follow the above steps your problem could get solved.