How to change content of datagridview based on datetime.now

Question

0.00/5 (No votes)

See more:

I have DataGridView, with three columns: Item Name, DateTime of Beginning of Auction, DateTime of closing of Auction (which is 5 minutes after the first DateTime).
I want to check if the time of closing expired and if it is expired, to change color of the that row. Aslo, if there is suggestion how to add countdown time for each row.
Thank you in advance

What I have tried:

Tried to find DataGridView property which handle this

Posted 20-Jun-19 20:57pm

Sinisa Janjetovic

Updated 20-Jun-19 21:17pm

Add a Solution

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)

OriginalGriff · Answer 1 · 2019-06-20T21:18:00

Solution 1

Start with the DataGridView.RowPrePaint[^] event: it is called for row just before it is drawn. In it, check the expiry and set the foreground / background colours appropriately.

You will also need a Timer to Invalidate the DGV so that it does get repainted.

To set a "countdown timer" for each row, use the same event and timer, and update the row "countdown" column.

Posted 20-Jun-19 21:18pm

OriginalGriff

Comments

Sinisa Janjetovic 21-Jun-19 3:34am

Thank you, unfortunately I can not find it in Properties for DataGridView

OriginalGriff 21-Jun-19 3:37am

It's an Event, not a property.
Properties are for data, Events are for action as a result of things happening ... Look at the properties pane and click the little lightning bolt.

Sinisa Janjetovic 21-Jun-19 3:47am

I did, but there is no event RowPrePaint

Maciej Los 21-Jun-19 3:55am

Take a deeper look. If this event is available in MSDN documentation, then it should be available in your project, unless it isn't a WinForm project.

OriginalGriff 21-Jun-19 3:57am

What events can you see?

Sinisa Janjetovic 21-Jun-19 3:58am

Data Grid View is in Windows Form

OriginalGriff 21-Jun-19 4:07am

Yes, and it has a RowPrePaint event: what events can you see?

Sinisa Janjetovic 21-Jun-19 4:15am

Beginning with Row, I can see only RowDetailsVisibilityChanged, nothing else

OriginalGriff 21-Jun-19 4:45am

That's not a DataGridView, it's a DataGrid - which means it's WPF not WinForms.

You need to be accurate about these things when you ask questions!

Sinisa Janjetovic 21-Jun-19 4:47am

Sorry, I am beginner in C# and in Visual Studio at all, still learning and I am trying to manage.