compare two dataGridView cell with date value?

Question

1.00/5 (1 vote)

See more:

in my c# windows form i have a dataGridView that loads the data from a table,

The dataGridView has 8 columns two of them have date value borrow_date and return_date.

I want to compare the of that two columns if the date of any return_date cell is greater that the date of borrow_date cell, make the background of that cell red or make it's fore color red.

Posted 20-Mar-14 21:13pm

honar.cs

Updated 20-Mar-14 21:14pm

Kenneth Haugland

v2

Add a Solution

2 solutions

Solution 2

You have to do it on rowdatabound event

C#

if(e.row.cells[return_date ColumnNo].text > e.row.cells[borrow_date ColumnNo].text)
{
// set background colour
}

Posted 20-Mar-14 21:41pm

jaideepsinh

Comments

Marcin Kozub 21-Mar-14 3:49am

RowDataBound is event for Web GridView. OP clearly ask for WinForms solution.
And comparing data as text is not a good idea btw...
Downvote.

Add a Solution

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

Marcin Kozub · Accepted Answer · 2014-03-20T21:31:00

Solution 1

All you need is CellFormatting event of your DataGridView control.

C#

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    if (this.dataGridView1.Columns[e.ColumnIndex].DataPropertyName == "return_date")
    {
        var returnDate = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells["return_date"].Value);
        var borrowDate = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells["borrow_date"].Value);
        if (returnDate > borrowDate)
        {
            e.CellStyle.BackColor = Color.Red;
            // e.CellStyle.ForeColor = Color.Red;
        }
    }
}

For more information take a look here:
http://msdn.microsoft.com/library/system.windows.forms.datagridview.cellformatting%28v=vs.110%29.aspx[^]

Hope it helps you :)

Posted 20-Mar-14 21:31pm

Marcin Kozub

Updated 21-Mar-14 7:27am

v4

Comments

honar.cs 21-Mar-14 3:35am

thank you Marcin Kozub for your answer ... what do you mean by columnindex == 5, i have two columns for date this mean two columnindex?

Marcin Kozub 21-Mar-14 3:45am

This means, that you must replace 5 (it was just sample number) with proper column index of your return_date column on your DateGridView component. If you have 8 columns, just enter value from 0-7. This is index of column that you want to color.
Remember that columns are numbered from 0.

Marcin Kozub 21-Mar-14 3:58am

I've updated my solution.

honar.cs 21-Mar-14 4:13am

ow you right thank you ... i have one more question please ... my project is for library and the borrow_date is the date that book is borrowed and the return_date is that borrower must return the book ... if the borrower does not return the book in the return_date at that time i want to make the return_date cell for that borrower red.. is your code do these or not?

Marcin Kozub 21-Mar-14 4:21am

Did you even tried to use this code? You have all informations that you need to acomplish your task by yourself :)

honar.cs 21-Mar-14 10:38am

i try this code ... but it does not work?

Marcin Kozub 21-Mar-14 10:57am

I assure you that my code works fine for you main question.
This modification will work for your new requirements:

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (this.dataGridView1.Columns[e.ColumnIndex].DataPropertyName == "return_date")
{
var returnDate = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells["return_date"].Value);
if (return_date < DateTime.Now)
{
e.CellStyle.BackColor = Color.Red;
// e.CellStyle.ForeColor = Color.Red;
}
}
}

honar.cs 21-Mar-14 13:12pm

in if (return_date < DateTime.Now), what is return_date do you mean returnDate? or not?

Marcin Kozub 21-Mar-14 13:27pm

Yes, it should be returnDate (it's a variable name). Sorry.

honar.cs 21-Mar-14 13:44pm

my bro the same thing it does not work ... i have two dates borrow_date = 2014/03/15 and return_date = 2014/03/18, it must make the background for the 2014/03/18 date red ... but it does not do this?

Marcin Kozub 21-Mar-14 14:35pm

One more question. Did you hooked up this code with your DataGridView's CellFormatting event?
If not:
1. Go to your form designer
2. Select your DataGridView component and open Properties windows
3. On properties window select go to events section
4. Find CellFormating event and from drop down list select dataGridVied1_CellFormating method
5. Run your program. All should be fine now.

honar.cs 21-Mar-14 14:38pm

@Marcin Kozub i do this same thing don't work? see this link image http://oi57.tinypic.com/210d24p.jpg

Marcin Kozub 21-Mar-14 14:57pm

Look, i really don't know where is your problem.
I've created simple app for you. You can download it from my dropbox: https://www.dropbox.com/s/263bbd61nk608rh/LibraryApp.zip
Let me know if it helped you.

Member 13870676 9-Mar-19 8:17am

Why dropbox link not showing to me

Member 13870676 9-Mar-19 8:17am

If i can get ur sample app this would be very helpful to me

Marcin Kozub 10-Mar-19 9:38am

Sorry, I don't have source any more. It is very old thread and I deleted sample project...

honar.cs 21-Mar-14 15:00pm

thank you marcin kozub , know i download it and see i hpoe it helps me

honar.cs 22-Mar-14 2:33am

thank you dear Marcin Kozub i found the problem and know it work

Marcin Kozub 22-Mar-14 7:13am

Glad I could help you :)

compare two dataGridView cell with date value?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

compare two dataGridView cell with date value?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us