Global.asax

Question

how to update a database when session expires (session time out occurs) or browser is closed

Abhimanyu K Vatsa · Answer

follow the easy way here you go In the code given below I'm updating the last visit of any registered user on my site. To do this I'm just catching the user identity and then updating appropriate last login information in db. Find the code below: void Session_End(object sender EventArgs e) { // Updating db here using (SqlConnection connection = new SqlConnection(GetConnectionString())) { string dt = DateTime.Now.ToString(); string loggeduser = HttpContext.Current.User.Identity.Name; string sql = UPDATE users SET last_login_date=@dt WHERE username=@loggeduser; connection.Open(); SqlCommand cmd = new SqlCommand(sql connection); SqlParameter[] pram = new SqlParameter[2]; pram[0] = new SqlParameter(@dt SqlDbType.VarChar 49); pram[1] = new SqlParameter(@loggeduser SqlDbType.VarChar 49); pram[0].Value = dt; pram[1].Value = loggeduser; for (int i = 0; i { cmd.Parameters.Add(pram[i]); } cmd.ExecuteNonQuery(); } */ } public string GetConnectionString() { return System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionString1].ConnectionString; }

nishant ranjan · Answer

thanks......... its working

Abhimanyu K Vatsa · Answer

no i think you are trying this in a bad way. place my code in try catch block also check the login method you will be using. provided code is live on my many sites. check by creating application variable when user login and use this instead of User.Identity.Name.

nishant ranjan · Answer

string loggeduser = HttpContext.Current.User.Identity.Name; here am not able to get the loggeduser name. the control goes to Application_Error(object sender EventArgs e)

nishant ranjan · Answer

but how can we update database through session end... i mean how to run update command in session_end in global.asax actually hv nt worked with global.asax

Jiteendra Sampathirao · Answer

Hi Better to write the functionality in Global.asax file.....

Amit Choudhary · Answer

Try to utilize page_unload event or Session_End event in global.asax