Hi

I am using VB.Net 2008.

I m binding DataGridView with collection.

I have a 3 fields of DateTime type.

Now at the time of loading it displays empty values in cell where date is null in database.

but after entering any value, when i try to delete it, it shows 1/1/0001.

I want empty cell on delete press.

Please help me to solve this prob.

Thanks in Advance

Thank you

Best Regards

Utkarsh Gajjar

Hi Utkarsh

Have you encountered some error saying that DateTime cannot be set as null?

If not, how do you set cell’s value to 1/1/0001 while deleting value? Code segment is appreciated.

If you have set the deleted DateTime Value with some value like 1/1/0001, we can make this special value disappear from DataGridView using DataGridView.CellFormatting event like this:

Code Snippet

Hi Utkarsh

Have you encountered some error saying that DateTime cannot be set as null?

If not, how do you set cell’s value to 1/1/0001 while deleting value? Code segment is appreciated.

If you have set the deleted DateTime Value with some value like 1/1/0001, we can make this special value disappear from DataGridView using DataGridView.CellFormatting event like this:

Code Snippet

HiJun Wang

Thank you

Yes , i encountered error of cannot convert DateTime to DBnull.

But , with your code,CellFormatting event it is solved.

Thanksa lot.

Thank you

Best Regards

Utkarsh Gajjar