How to format DateTime columns in DataGridView

Question

I m using a DataGridView with object data binding to display information about logging entities in a system  retrieved via SOAP from a remote service  One of the columns is called  Last action  and means the last time the entity logged a message  It is a System DateTime value  When I read the SOAP response  example below   he timestamp obviously contains all the information  up to second fractions    lt LoggingEntity gt   lt host gt marty86ce lt  host gt   lt process gt 10148 lt  process gt   lt logger gt http core lt  logger gt   lt appName gt httpd lt  appName gt   lt ffda gt true lt  ffda gt   lt lastAction gt 2010-10-27T12 00 19 5117509Z lt  lastAction gt   lt lastHeartbeat gt 0001-01-01T00 00 00 lt  lastHeartbeat gt   lt channelId gt em 9BA2A2B4D0B6E66 lt  channelId gt   lt ffdaChannelId gt em E7C8D1D4DE8EEB9 lt  ffdaChannelId gt   lt  LoggingEntity gt    When I display it on the table  I instead can read up to the minutes  I use the following code to do the data binding when I press the refresh button  public void RefreshEntities         IEntityManagement management   EntityPlugin GetProxy        LoggingEntity   result   management FindLoggingEntities new TemplateQuery   ffdaSpecified   true  ffda   true       Remote invocation      Invoke new MethodInvoker delegate   gridEntities DataSource   result         THIS does the data binding from the array      Invoke new MethodInvoker delegate   btnRefresh Enabled   true           I would like to know how to control column formatting of data bound values  I think that the format dd MM yyyy hh mm comes from my system s settings  How to override formatting settings programmatically   Thank you in advance  Full solution code on Subversion  FFDAGui program  for the Logbus-ng open source project

User · Accepted Answer

If it is a windows form Datagrid  you could use the below code to format the datetime for a column  dataGrid Columns 2  DefaultCellStyle Format    MM dd yyyy HH mm ss     EDIT    Apart from this  if you need the datetime in AM PM format  you could use the below code  dataGrid Columns 2  DefaultCellStyle Format    MM dd yyyy hh mm ss tt

User · Answer

You can set the format in aspx  just add the property  DateFormatString  in your BoundField   DataFormatString   0 dd MM yyyy hh mm ss

User · Answer

string stringtodate     DateTime row Cells 4  Value  ToString  MM-dd-yyyy    textBox9 Text   stringtodate

User · Answer

Published by Microsoft in Standard Date and Time Format Strings   dataGrid Columns 2  DefaultCellStyle Format    d      Short date   That should format the date according to the person s location settings   This is part of Microsoft s larger collection of Formatting Types in  NET

User · Answer

I used these code Hope it could help  dataGridView2 Rows n  Cells 3  Value   item 2  ToString    dataGridView2 Rows n  Cells 3  Value   Convert ToDateTime item 2  ToString    ToString  d

User · Answer

You can set the format you want   dataGridViewCellStyle Format    dd MM yyyy   this date DefaultCellStyle   dataGridViewCellStyle     date being a System Windows Forms DataGridViewTextBoxColumn

User · Answer

Use Column DefaultCellStyle Format property or set it in designer

[c#] How to format DateTime columns in DataGridView?

Examples related to c#

Examples related to winforms

Examples related to data-binding

Examples related to datetime

Examples related to datagridview