Maintaining user log in the database

Adeel Mirza 121

In my ASP.NET application I am maintaining user log in the database. Whenever a user logs in, his user details, and login time is saved in the database and when the user logs out his log out time is saved.

Now the problem arises, if the user doesn't log out and his session expires. In this case I am unable to save his logout time. In Golbal.ascx. I cannot Session_End I cannot call such ADO.NET operation.

How can I overcome this.

Yijing Sun-MSFT 7,066 Reputation points

2022-05-10T08:33:05.027+00:00

Hi @Adeel Mirza ,
Once the session times out, the Session_End() event will be triggered and you can capture your logout in there. Why you cannot use the Session_End()?

Best regards,
Yijing Sun
AgaveJoe 26,136 Reputation points

2022-05-10T11:12:45.397+00:00

The standard method is to update a last access time by user on each request. If the user last access time plus the authentication timeout period has passed then the user has logged out.