One of the common objectives in projects is to display date in M-DD-YYYY format in GridView. The GridView may be bound dynamically from a database, XML, CSV, WebService or any other data source.

Let us take a small snippet to solve this problem at a go:

 

 

<asp:GridView ID=”dgVolunteers” runat=”server” SkinID=”GridTheme” Width=”100%” AutoGenerateColumns=”False” >

<Columns>
<asp:BoundField HeaderText=”Member Since” DataField=”TimeStamp”
DataFormatString=”{0:M-dd-yyyy}” />
</Columns>

</asp:GridView>

This will print date like “5-06-2008”

However, if the need of the hour is to display the time as well, add an attribute HtmlEncode=“false” to asp:BoundField. There is no change in the way in which you bind a data source to your grid using C# or VB.NET.

Here are some of the string formats that you can try out:

Specifier type output
(June 8, 1970 12:30:59)
dd Day 08
ddd Short Day Name Mon
dddd Full Day Name Monday
hh 2 digit hour 12
HH 2 digit hour (24 hour) 12
mm 2 digit minute 30
MM Month 06
MMM Short Month name Jun
MMMM Month name June
ss seconds 59
tt AM/PM PM
yy 2 digit year 70
yyyy 4 digit year 1970
: seperator, e.g. {0:hh:mm:ss} 12:30:59
/ seperator, e.g. {0:dd/MM/yyyy} 08/06/1970