the page load event execute twice

Question

the page load event execute twice

sabry sabry 1

if have this link in word file when click it open the page offers.aspx
http://localhost:54818/offerslinks/offers.aspx?Offerid=80

and in the page load I wrote this code

   protected void Page_Load(object sender, EventArgs e)  
    {  
    if (!IsPostBack)  
    {  
        // GET THE ID OF THE OFFER   
        string id = Request.QueryString["Offerid"];  
        // GET THE LINK AND THE LINK COUNT   
        
        if (id != null)  
        {  
            string linkName = "";  
            string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;  
            using (SqlConnection con = new SqlConnection(cs))  
            {  
                SqlCommand cmd = new SqlCommand("SpOfferbyId", con);  
                cmd.CommandType = CommandType.StoredProcedure;  
                SqlParameter paramid = new SqlParameter("@ID", Convert.ToInt32(id));  
                cmd.Parameters.Add(paramid);  
                con.Open();  
                SqlDataReader rdr = cmd.ExecuteReader();  
                while (rdr.Read())  
                {  
                    linkName = rdr["Link"].ToString();  
                     
                }  

                Response.Redirect(linkName,false);  
                id = string.Empty;  
            }  

        }//end if   

          
    }

when I made debugging I found the query string read the parameter and execute the code 1- execute the page-load of page content 2- execute the page-load of the master page 3- ec=xecute the page-load of the content page again

ps: the page is empty

AgaveJoe 30,126 Reputation points

2022-07-06T13:49:05.82+00:00
The Page_load fires once unless the page is called twice or in very rare cases the Page_Load event is manually called. the code has a redirect.

Response.Redirect(linkName,false);

If link name is the same as the current aspx page name then it makes sense that Page_Load is called twice. Anyway please use the Visual Studio debugger to flow the code flow. Otherwise, post all the relevant code if you need the community to review/debug your code.
sabry sabry 1 Reputation point

2022-07-06T15:41:30.893+00:00

first, the link goes to the other website
Response.Redirect(linkName,false); example https://www.google.com/
i used a debugger i found the steps of execution are :
1- execute the page-load of page content
2- execute the page-load of the master page
3- execute the page-load of the content page again
my code is simple
1- URL to click (http://localhost:54818/offerslinks/offers.aspx?Offerid=80)
2- read the query string
3- execute the stored procedure
CREATE proc SpOfferbyId
@ID int
as
begin
select DISTINCT link from TblOfferLink where id =@ID
declare @my_int int ;

set @my_int = (select DISTINCT LinkCount from TblOfferLink where Id =@ID) ;
set @my_int = @my_int +1;

update TblOfferLink set LinkCount = @my_int where Id=@ID
end
4- make the redirect
there is no any user control in the page only the code of execute the stored procedure

any help
Yijing Sun-MSFT 7,096 Reputation points

2022-07-07T01:57:15.393+00:00

Hi @sabry sabry ,
I suggest you could share all codes to us. It will help us to solve your problems.
Best regards,
Yijing Sun
Viorel 122.6K Reputation points

2022-07-07T04:08:48.727+00:00

If you think that the problem is caused by the shown code, comment it and check if Page_Load is still called twice. Also try accessing the link manually from browser.

You can also try a simpler ASP page that does not use Master page.

2 answers

Your answer

AgaveJoe 30,126 Reputation points

2022-07-06T13:49:05.82+00:00

The Page_load fires once unless the page is called twice or in very rare cases the Page_Load event is manually called. the code has a redirect.

Response.Redirect(linkName,false);

If link name is the same as the current aspx page name then it makes sense that Page_Load is called twice. Anyway please use the Visual Studio debugger to flow the code flow. Otherwise, post all the relevant code if you need the community to review/debug your code.
sabry sabry 1 Reputation point

2022-07-06T15:41:30.893+00:00

first, the link goes to the other website
Response.Redirect(linkName,false); example https://www.google.com/
i used a debugger i found the steps of execution are :
1- execute the page-load of page content
2- execute the page-load of the master page
3- execute the page-load of the content page again
my code is simple
1- URL to click (http://localhost:54818/offerslinks/offers.aspx?Offerid=80)
2- read the query string
3- execute the stored procedure
CREATE proc SpOfferbyId
@ID int
as
begin
select DISTINCT link from TblOfferLink where id =@ID
declare @my_int int ;

set @my_int = (select DISTINCT LinkCount from TblOfferLink where Id =@ID) ;
set @my_int = @my_int +1;

update TblOfferLink set LinkCount = @my_int where Id=@ID
end
4- make the redirect
there is no any user control in the page only the code of execute the stored procedure

any help
Yijing Sun-MSFT 7,096 Reputation points

2022-07-07T01:57:15.393+00:00

Hi @sabry sabry ,
I suggest you could share all codes to us. It will help us to solve your problems.
Best regards,
Yijing Sun
Viorel 122.6K Reputation points

2022-07-07T04:08:48.727+00:00

If you think that the problem is caused by the shown code, comment it and check if Page_Load is still called twice. Also try accessing the link manually from browser.

You can also try a simpler ASP page that does not use Master page.

Answer 1

Bruce (SqlWork.com) 77,686 Volunteer Moderator

Use the browsers network trace to see if it calls twice. An empty img or style href will do this.

sabry sabry 1 Reputation point

2022-07-08T15:31:56.207+00:00

I used the browser trace network I found when I click the link http://localhost:54818/offerslinks/offers.aspx?Offerid=80
from the file word, I cause the execution twice but when I copy it and paste it in the browser URL and click enter it does not cause any twice execution does anyone knows why that happens?
Yijing Sun-MSFT 7,096 Reputation points

2022-07-11T02:09:11.01+00:00
Hi @sabry sabry ,
For your link to work, it must use a PostBack to notify the server that an event has occurred.

The way the ASP.Net lifecycle works, the page must be loaded before a post back event (like clicking the link) is handled, so that it knows how to handle that event. So when you click a link, the page calls the following events:

PreInit -> Init -> InitComplete -> PreLoad -> Load -> Your event handler

If your link causes a redirect, at this point, the page will be redirected and restart the page life cycle.
That's why it load twice. I think you could share you full codes to us. It will help us to solve your problems.
Best regards,
Yijing Sun

Answer 2

You might perhaps want to post the button (markup) used.

I have several times over the years wasted a whole after noon.

take this simple button:

And, you get this:

Now, in MOST cases, I use a asp.net button), but a plain jane button I often use since I can then with greater ease include a bootstrap glyphicon as per above.

So, any readers see a problem with above?

No, you don't. Now, I not been able to determine WHEN, but we OFTEN will find the above button when clicked will fire 2 times. (and that means page load fires two times, and then the event code for the button ALSO fires two times!!!).

Solution:

Add type button to the markup:

So, the above is probably NOT your issue - but if you using a button as opposed to a asp.net button, then do check the above.

and if you using a standard asp.net button? Then do not have BOTH a onclick="my event stub", and a handles event for the button. (use one, or the other - if you use both, then you again get the button code to trigger two times).

Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada

Share via

the page load event execute twice

2 answers

Your answer