Need to run the update script when the user exits the page - ASP.NET (C#)

Hi,

Need to do two things:

1. Run one update statement when user comes on a particular page
2. Run another update when user exists that page.

Sr.no 1 can be done on Page_Load event.

For Srno.2,  User can exit the page in two ways:
(a) Closing the browser
(b) Clicking the link of other page.

How do I run the update when the user exists the page through above two cases (i.e. a & b)?

Thanks!

meetpdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rahul Goel ITILSenior Consultant - DeloitteCommented:
See, both approaches can be achieved using javascript event handlers. and make a ajax call to the server
 
Here is the code for trapping windows close

<html>
<head>
<title>Detecting browser close in IE</title>
 
 
<script type="text/javascript">
 
var myclose = false;
 
function ConfirmClose()
{
if (event.clientY < 0)
{
event.returnValue = 'Any message you want';
 
setTimeout('myclose=false',100);
myclose=true;
}
}
 
function HandleOnClose()
{
if (myclose==true) alert("Window is closed");
}
 
</script>
</head>
 
 
<body onbeforeunload="ConfirmClose()" onunload="HandleOnClose()">
 
<h4>Close browser!</h4>
 
</body>
</html> 

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
meetpdAuthor Commented:
Can I put an sql update statement in this? How?

Sorry for the silly question, but I am a newbie.
0
DreamsTechCommented:
U can call any evnet from the javascript function:

Put a Attribute ScriptMethod: on the Method to be called
 and call this from javascript call

 PageMethods.UpdateQuerry();

in ur cs file

[ScriptMethod:]
UpdateQuerry()
{

  //Update Query
}
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.