Global.asax

nishant ranjan

15y2.4k.NET

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhimanyu K Vatsa15y ago
Accepted 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 < pram.Length; i++)
{
cmd.Parameters.Add(pram[i]);
}
cmd.ExecuteNonQuery();
} */
}

public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString;
}
nishant ranjan15y ago
thanks......... its working
Abhimanyu K Vatsa15y ago
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 ranjan15y ago
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 ranjan15y ago
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 Sampathirao15y ago
Hi,
Better to write the functionality in Global.asax file.....
Amit Choudhary15y ago
Try to utilize page_unload event or Session_End event in global.asax