Calling javascript before pageload

Question

0.00/5 (No votes)

See more:

I have a function on pageload where I am using values from labels(day and month). I am getting values of these labels from a js function in a sql query but these values remain empty at the time of pageload coz js runs after pageload. Is there a way to resolve this?? Any help would be greatly appreciated.
Thanks

js function is a follows:

JavaScript

<script type="text/javascript">
    function time() {
        var currentTime = new Date();
        var day = currentTime.getDate();
        var month = currentTime.getMonth() + 1;
        document.getElementById("day").value = day;
        document.getElementById("month").value = month;
    }
</script>

Sql query is as follows:

C#

"select logo,companyname from logos where status='True' AND type='Birthdays' AND day='"+day.Text.ToString()+"' AND month='"+month.Text.ToString()+"'"

Posted 27-Jun-13 1:51am

lucky050

Updated 27-Jun-13 2:08am

Ankur^\m/

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankur^\m/ · Answer 1 · 2013-06-27T02:07:00

For this you have to first understand how ASP.NET applications work.
When the page is requested by the browser for the first time, the request is sent to the web server where ASP.NET engine process your request and converts it into HTML and renders back to the browser. This is when your JavaScript and HTML are available to the browser. Now you can execute any JavaScript code and change a control's value. And if you post the page again, the ASP.NET will then have the updated value.

Now let's consider your scenario. You want the value of day and month controls on the server side and you assign them values on client side (using javascript). So these values will only be available once you POST the form back to asp.net server (called a postback).
I see that your calculation isn't based on any user input. So this can also be done on the server side. On the page load calculate these values (assign them to the controls if needed) and call the database query.
That will solve your problem.

If you control values still have to depend on JavaScript calculations, you will have to post the form either completely or partially (using AJAX).

Mahesh Bailwal · Answer 2 · 2013-06-27T02:12:00

You can create same query in Page_Load itself as long you don't need any input from user using below code

protected void Page_Load(object sender, EventArgs e)
    {
        var query = "select logo,companyname from logos where status='True' AND type='Birthdays' AND day='" + DateTime.Now.Day.ToString() + "' AND month='" + DateTime.Now.Month.ToString() + "'";
    }

Calling javascript before pageload

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0