Udate table in Sqlserver 2008 on any Browser close

Question

I want to update a database(Sqlserver 2008) on browser close. I have a table in which i have value 0 I want that 0 should be updated to 1 whenever user closes the browser. How can i do this?.

Gohil Jayendrasinh · Answer

Hi try it it's working var preventUnloadPrompt; var messageBeforeUnload = my message here - Are you sure you want to leave this page?; $('a').live('click' function () { preventUnloadPrompt = true; }); $('form').live('submit' function () { preventUnloadPrompt = true; }); $(window).bind(beforeunload function (e) { var rval; if (preventUnloadPrompt) { return; } else { //location.replace(redirectAfterPrompt); return messageBeforeUnload; } return rval; }) call ajax method and update your records.

Kunal Vaishya · Answer

Dear try this text/javascript language= javascript > window.onbeforeunload = function( event ) { var msg = 'Are you sure you want to leave?' ; if (((window. event .clientX || event .clientX) 0 ) || ((window. event .clientY || event .clientY) 0 )) // close button { event=window. event ; event .returnValue = msg; return msg; } if ((window. event .clientX 0 ) || (window. event .clientY 0 )) // close button { event=window. event ; event .returnValue = msg; return msg; } else if (window. event .altKey == true || window. event .ctrlKey == true ) // ALT + F4 { event=window. event ; event .returnValue = msg; return msg; } else // for all other unload events { } } script >