C# winform remove date from datagridview

Question

0.00/5 (No votes)

See more:

I have a winform with datagridview MS Access database. I have 2 columns linked to datetimepicker. In code I copy the date from one column to the other and the copied cell is blank. when I reopen the form the blank cell shows 12/30/1899. How can i keep it blank until I enter another date?

This is the code I use to copy from one cell to the other (button click)

C#

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
       {

           if (e.ColumnIndex == dataGridView1.Columns [19].Index)
           {

               {
                   dataGridView1.CurrentRow.Cells[16].Value = dataGridView1.CurrentRow.Cells[17].Value;
                   dataGridView1.CurrentRow.Cells[17].Value =  "";
               }
           }
       }
   }
   }

What I have tried:

Custom format
And

this.dateTimePicker1.Format = DateTimePickerFormat.Custom;
this.dateTimePicker1.CustomFormat = " "; //a string with one whitespace

Posted 17-Jan-20 10:01am

Member 12349103

Updated 18-Jan-20 23:13pm

Add a Solution

Comments

[no name] 18-Jan-20 10:33am

Try assigning null instead of an empty string.

2 solutions

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)

ashid das11 · Answer 1 · 2020-01-18T07:02:00

Solution 1

dataGridView1.CurrentRow.Cells[17].Value =null

Posted 18-Jan-20 7:02am

ashid das11

Comments

Member 12349103 18-Jan-20 15:28pm

It still shows 12/30/1899 when I reopen the app / database

ashid das11 21-Jan-20 12:47pm

Can you share the screenshot, before and after

Member 12349103 25-Jan-20 10:41am

How do I add screen shots?

User 11060979 · Answer 2 · 2020-01-18T23:14:00

Looks like you need to implement CellFormatting. The docs you can find here: DataGridViewCellFormattingEventArgs Class (System.Windows.Forms) | Microsoft Docs[^]

Your implementation will then look something like this

C#

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs formatting)
{
   if (e.ColumnIndex == 17)
   {
       // Here the decision what we like to show as blank. Depending on the situation 
       // you may need also to check for null Value 
       //
       // Additinal this gives you also the option to compare Col16 with Col17
       // on equality which means you don't need to set Col17 to null or empty string
       if ((DateTime)dataGridView1.CurrentRow.Cells[17].Value == DateTime.MinValue)
       {
           formatting.Value= "";
       }
   }
}

Better to work with column names than indices

C#

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs formatting)
{
   if (this.dataGridView1.Columns[e.ColumnIndex].Name == "Column3")
   {
       if ((DateTime)dataGridView1.CurrentRow.Cells["Column3"].Value == DateTime.MinValue)
       {
           formatting.Value= "";
       }
   }
}