Hi,
      I using asp and sql server.I can stored in database in logout time and login status .
but when i closed browser then session was not expire.
and second thing is i can set session is 20 min when after 20 mins session will be expire.
but not updated logout time and status .

it show Logout time and status is "on"

.how can when i closed browser that time logout time and status is off.


I give query


Set con = Server.CreateObject("ADODB.Connection")
 con.open "intatanet"
 qq2 = "UPDATE LoginHistory SET LoginHistoryOutTime='"& now() &"',LoginHistoryStatus='N' Where LoginHistoryStatus='Y' and LoginHistorySessionID = " & Session.SessionID & " "
 'Response.Write qq2
 'Response.End
 Set rs=con.Execute(qq2)


this query is run propery when i logout in logout button. but when i closed browser then cant update logout time and staus.

how can do this.please help me asap.

thanks

In your global.asax file you have a method: Session_End I would suggest placing the above code in that method so that when the session terminates, it will fire that query.

"The one language all programmers understand is profanity."

HI,

    I did it,but it cant work.How can update database and how.

pls help me again.

It does work, but you actually have to wait for the session to expire on the server; what i mean is that if i were to navigate to your page login and look around then just close the browser window, the Session_End event will eventually fire, after my session has timed out. (By default this is 15 mins)

You are probably going to have to write a Javascript that watches for the page to be closed and if it detects that, it is going to have to call a server side method to fire your query.

"The one language all programmers understand is profanity."

If you are using IE, then look up the OnBeforUnload event:

http://www.webreference.com/dhtml/di.../bunload3.html

It is for IE 4 and up only.

Hi,

I have the same problem I have to update the field in the database whenever the browser is closed. My application is in asp.net 2.0.

Did ur problem get solved....

If yes?

Please help me out ...

Thanks in Advance
Bhanu