Solved

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

Posted on 2009-07-05
3
182 Views
Last Modified: 2012-05-07
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!

0
Comment
Question by:meetpd
3 Comments
 
LVL 9

Accepted Solution

by:
Rahul Goel ITIL earned 400 total points
ID: 24782450
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
 

Author Comment

by:meetpd
ID: 24782581
Can I put an sql update statement in this? How?

Sorry for the silly question, but I am a newbie.
0
 
LVL 3

Assisted Solution

by:DreamsTech
DreamsTech earned 100 total points
ID: 24783001
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now