Change datalist row background color if based on time compared with datetime column

Question

1.00/5 (1 vote)

See more:

i am having a registration page where a candidate registers and i am having a screen which displays all the candidates registered names( In Datalist control). the user waits for his turn for the next round and can see his name on display waiting list.
i am having a datetime column with getdate() function in sqlserver .

From the time candidate has registered i want to change background color of particular row i.e if candidate time passes 30 minutes background color of datalist row should be changed to orange and if crosses one hour color should be changes to red..

How do i do this

What I have tried:

i Have been checking with others forums for this but did not get appropriate results.

Posted 21-Jun-17 21:27pm

Member 12674660

Updated 25-Jun-17 23:50pm

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Jun-17 5:37am

What have you tried?

sachin.vishwa90 22-Jun-17 9:38am

how frequent does your data in listview changes? does your list view shows only name?

Member 12674660 23-Jun-17 15:49pm

if changes when the name in listview is changed by user

1 solution

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)

sachin.vishwa90 · Answer 1 · 2017-06-25T23:50:00

you can achieve this using jquery if you don't need to save the color in database
There is a setInterval function in javascript which runs after every specified second.
you can make use of that function in following order
to know about setInterval

javascript - Looping through list items with jquery - Stack Overflowto loop through list view and get the values

JavaScript

<script>
setInterval(function(){ alert("Hello"); }, 2000);

function changeRowColor(){
 // loop through each row and take the time as string from column
 // compare that time with current time.
 // if time difference is more than x mins or y seconds
 // change the color of row

}

<script>