Need C# code Update the Table

Question

Hi.. I need one c# code to update the table when the browser is closed or web application tab is closed.

Midhun T P · Answer

Hi As per my knowledge there is no way you can identify the closing of browser or tabs from c#. The only option is to use onbeforeunload function in clientside for the same. Please refer below link- http://www.w3schools.com/jsref/event_onbeforeunload.asp In the script you can call ajax page to update the table- function myFunction() { //Here call ajax function return ; } Not sure about whether it works on every browser or works perfectly. You have to test it thoroughly.

Delpin Susai Raj · Answer

insertupdatedelete query have this link http://lamahashim.blogspot.in/2010/04/c-read-insert-update-delete-from-sql.html

Delpin Susai Raj · Answer

string querystr = UPDATE Users SET User_FirstName='@User_FirstName' User_LastName='@User_LastName' WHERE User_ID='@User_ID';

Delpin Susai Raj · Answer

string querystr = UPDATE Users SET User_FirstName=@User_FirstName User_LastName=@User_LastName WHERE User_ID=@User_ID;

Delpin Susai Raj · Answer

view this link http://stackoverflow.com/questions/19723545/c-sharp-update-sql-server-table