Timer countdown sql, asp.net c#, javascript

Question

i have the next javascript code:

 <script language="JavaScript">
  TargetDate = "12/31/2020 5:00 AM";
  BackColor = "palegreen";
  ForeColor = "navy";
  CountActive = true;
  CountStepper = -1;
  LeadingZero = true;
  DisplayFormat = "%%D%% Days, %%H%% Hours, %%M%% Minutes, %%S%% Seconds.";
  FinishMessage = "the auction end"
  </script>
   <script language="JavaScript" src="countdown.js"></script>

my question is... how to do that the TargetDate will get the datetime from sql table? i have sql table with the desgin: id, auctionEndTime .... how i'm connect that to the targetdate? it is possible?

FIre Panda · Accepted Answer · 2011-05-16 13:48:26Z

1

Javascript runs at clientside so it can't access the database directly. However, you could call a service from javascript and that service could fetch the record from the database in JSON format or may be in your custom format. However, If you need to fetch the value only once that is when page loads, so you could add a hidden field to the page, sets the hidden field value to whatever value you like to at serverside, fetch the hidden field value from javascript and set it to TargetDate.

edited May 16, 2011 at 13:48

answered May 16, 2011 at 13:39

FIre Panda

6,6272 gold badges28 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Steven Ryssaert · Accepted Answer · 2011-05-16 14:16:31Z

0

You could use a property in code behind to fill up the javascript directly.

ASP.Net page:

<script language="JavaScript">
  TargetDate = "<% = TargetDate %>"; /*this is a property in code behind*/
  BackColor = "palegreen";
  ForeColor = "navy";
  CountActive = true;
  CountStepper = -1;
  LeadingZero = true;
  DisplayFormat = "%%D%% Days, %%H%% Hours, %%M%% Minutes, %%S%% Seconds.";
  FinishMessage = "the auction end"
</script>
<script language="JavaScript" src="countdown.js"></script>



Page code behind:

public string TargetDate{
  // Build code to get date from database
  string sql = "SELECT targetDate from Events where Event_ID = 1309";
  // execute sql
  // ...
  return dbvalue;
}

answered May 16, 2011 at 14:16

Steven Ryssaert

1,97715 silver badges28 bronze badges

3 Comments

Steven Ryssaert Over a year ago

As a side-note, I'd like to add that it would be nice to fetch the value in ´Page_Load´ and set it to a private variable. The private variable would then be called through the property.

Oshrib Over a year ago

Thank you very much... because i regular to use LINQ to SQL .. i don't know how to build here the code to get date from database. my table: Timer and the column name: endTime i will very appricate if you give me that last help... thank you anyway !

Steven Ryssaert Over a year ago

@Bside: Take a look at this article

V4Vendetta · Accepted Answer · 2011-05-16 13:41:49Z

0

You can possibly set the value in a hidden field after querying the Database and access the value from the field in your Javascript function

answered May 16, 2011 at 13:41

V4Vendetta

38.5k9 gold badges83 silver badges84 bronze badges

2 Comments

Oshrib Over a year ago

Its sounds intresting... can you explain more detailed?

Jimmie R. Houts Over a year ago

@Bside, you would use an <asp:Hidden/> control in your page and set the value of it from the server side. You could then get the value of the control via JavaScript and store it in your TargetDate variable.

Jimmie R. Houts · Accepted Answer · 2011-05-16 13:49:33Z

0

You could also use the ClientScript methods from the appropriate place in your code-behind:

ClientScript.RegisterClientScriptBlock(this.GetType(), 
                                       "AuctionTargetDateScript", 
                                       string.Format("TargetDate = '{0}';", TargetDateFromDB), 
                                       true);

Have a look at this MSDN page for more details on the methods availabe via ClientScript.

answered May 16, 2011 at 13:49

Jimmie R. Houts

7,8682 gold badges33 silver badges38 bronze badges

Collectives™ on Stack Overflow

Timer countdown sql, asp.net c#, javascript

4 Answers 4

Comments

3 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related