DataGridView replace value

Question

dataGridView has column DataGridViewTextBoxColumn, that reads from my database.
I need to replace one value to another, example:

If in field "date" I have value "00.00.0000" - I need to replace it to text "absent".
How can i do this?

Answer 1

You have to use the DataGridView.CellFormatting event. With that you can easily format your cell and its text to whatever you need, based on its value. This example explains it in detail.