How to format datetime to only specific DATE format in datatable

Question

In my datagridview1, the DATE column show format "MM/dd/yyyy hh:mm:ss"

Then I use this code.

I use a function to fill a datagridview like this

public void load_table()
{
    DataTable ltdgv = getLoad_table(); 
    //the getLoad_table() function return a datatable type and store it to ltdgv

   foreach (DataRow dr in ltdgv.Rows)
   {
       dr["DATE"] = DateTime.Parse((dr["DATE"].ToString())).ToShortDateString();
   }

   dataGridView1.DataSource = ltdgv;           
}

but the DATE column still showing format MM/dd/yyyy [ex: 11/27/2016]

but I want to change it to dd/MM/yyyy or 27/11/2016

I tried to change it into =

dr["DATE"] = DateTime.Parse((dr["DATE"].ToString("dd/MM/yyyy"))).ToShortDateString();
// I fill a parameter to the .ToString()

But I now get a "syntax error".

So, how to fix this?

Steve · Accepted Answer · 2016-12-03 11:52:45Z

9

Do not try to change the 'format' of a datetime column in a datatable.
Simply a DateTime has no format by itself.

It is the tool that you use to display the date that has the task to present it in a human readable format, whatever this format is.

In other words. It is the DataGridView that must carry out this task.

You just need to set

dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";

(Assuming that the grid column at index zero is your date column)

edited Dec 3, 2016 at 11:52

answered Dec 3, 2016 at 11:47

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ronan Boiteau · Accepted Answer · 2019-07-25 22:10:00Z

4

Place the custom format in the output ToString(), not the input.

foreach (DataRow dr in ltdgv.Rows)
{
    dr["DATE"] = DateTime.Parse((dr["DATE"].ToString())).ToString("dd/MM/yyyy");
}

edited Jul 25, 2019 at 22:10

Ronan Boiteau

10.3k7 gold badges39 silver badges62 bronze badges

answered Dec 3, 2016 at 11:47

Troy Mac1ure

6474 silver badges9 bronze badges

Comments

Grigory Zhadko · Accepted Answer · 2021-05-14 13:01:06Z

0

In case of asp:BoundField

<asp:BoundField DataField="BirthDate" HeaderText="Birth Date" DataFormatString = "{0:dd/MM/yyyy}"  />

In case of asp:TemplateField

<asp:TemplateField HeaderText="Birth Date" ItemStyle-Width="120px" >
    <ItemTemplate>
        <asp:Label Text='<%# Eval("BirthDate", "{0:dd, MMM yyyy}") %>' runat="server" />
    </ItemTemplate>
</asp:TemplateField>

edited May 14, 2021 at 13:01

Grigory Zhadko

1,8841 gold badge28 silver badges39 bronze badges

answered May 14, 2021 at 7:23

kiran kumar k s

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

How to format datetime to only specific DATE format in datatable

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related