Countdown timer

Question

Good day friends Pls can someone help me. I want to show a countdown timer in my gridview for each item in sql database having startdate and enddate columns in my database. Any help will be appreciated.

Kanak · Answer

i wil try daniel... iam using javascript ajax methodC# webmethod to get data from DB.

Ikechukwu Daniel · Answer

Tnx Kanak. I will try it. Can you also give a sample of code behind to fetch the date from the startdate column and then show it in my gridview for all the products.

Kanak · Answer

please try this way Data format must like this  keep this array format from your database like this format $(document).ready(function () { var datearray = [ ['div_id_1''Match 1' '2017/10/10 12:34:56'] ['div_id_2''Match 2' '2017/10/11 12:34:56'] ['div_id_3''Match 3' '2017/10/12 12:34:56'] ['div_id_4''Match 4' '2017/10/13 12:34:56'] ['div_id_5''Match 5' '2017/10/14 12:34:56']]; $(#div_timer).append( ); $.each(datearray function (k v) { $(#div_timer).append( ); $(# + v[0]).countdown(v[2]) .on('update.countdown' function (event) { var format = '%H:%M:%S'; if (event.offset.days > 0) { format = '%-d day%!d ' + format; } if (event.offset.weeks > 0) { format = '%-w week%!w ' + format; } $(this).html( v[1]+' ----- '+event.strftime(format)); }) .on('finish.countdown' function (event) { $(this).html(' ') .parent().addClass('disabled'); }); }); $(#div_timer).append( ); });