0

when i leave the page i want to capture the current Time. i have tried this below code but its not working please help me

protected void Page_Unload(object sender, EventArgs e)
        {
            SqlCommand cd = DbCon._dbConnection.CreateCommand();
            cd.CommandType = CommandType.Text;
            cd.CommandText = "update ViewTime set ViewExit= '" + DateTime.Now.ToString() + "' where ViewExit is null";
            cd.ExecuteNonQuery();
        }

and tried this below code

     protected void Page_Unload(object sender, EventArgs e)
       {
          SqlCommand cd = DbCon._dbConnection.CreateCommand();
          cd.CommandType = CommandType.Text;
          cd.CommandText = "update Timepdf set Viewstop= '" + 
          DateTime.Now.ToString() + "' where Viewstop is null";
          cd.ExecuteNonQuery();
       }
Shruthi Kadam Kadam
  • 1
  • 3
  • 1
    The unload event fires when the page is unloaded from the processing pipeline on the server **not** when the user closes the page. – Alex K. Jul 07 '21 at 12:10
  • You can try to use [`window.onbeforeunload`](https://stackoverflow.com/questions/28627111/how-to-call-a-function-before-leaving-page-with-javascript). – Yiyi You Jul 08 '21 at 02:13

0 Answers0