Pages

Friday, June 3, 2011

DateTime Format in GridView ItemTemplate In Asp.net C#

DateTime Format in GridView ItemTemplate In Asp.net C#

To format DateTime in GridView In ItemTemplate we have to pass format in eval or bind . There are many format available for the
DateTime .In this article i have given some example that how to format datetime and at end i have listed the datetime format
used in gridview .

Following are  the examples of ItemTemplate where format used for datetime .

<asp:TemplateField>
    <ItemTemplate>
        <asp:Label ID="lblDate" runat="server" Text='<%# Eval("Date", "{0:dd/MM/yyyy}")%>' ></asp:Label>
    </ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
    <ItemTemplate>
        <asp:Label ID="lblDat1" runat="server" Text='<%# Eval("Date", "{0:D}")%>' ></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

Following are  the examples of BoundFieldwhere format used for datetime .

<asp:boundfield datafield="DOB" dataformatstring="{0:d}" headertext="Date Of Birth" readonly="True"> </asp:boundfield>

The following table shows some date format strings that can be used to format date in GridView columns,

Format Pattern Name Example
d Short date 11/8/2008
D Long date Sunday, August 11, 2008
t Short time 3:32 PM
T Long time 3:32:00 PM
f Full date/time (short time) Sunday, August 11, 2008 3:32 PM
F Full date/time (long time) Sunday, August 11, 2008 3:32:00 PM
g General date/time (short time) 8/11/2008 3:32 PM
G General date/time (long time) 8/11/2008 3:32:00 PM
m or M Month day August 11
r or R RFC 1123 Sun, 11 Aug 2008 8:32:00 GMT
s Sortable date/time 2008-08-11T15:32:00
u Universable sortable date/time 2008-08-11 15:32:00z
U Universable sortable date/time Sunday, August 11, 2008 11:32:00 PM
y or Y Year month August, 2008


Related Other posts

14 comments:

  1. Thanks for the quick reference guide on formatting dates!

    ReplyDelete
  2. thank you , it realy helped me ...

    ReplyDelete
  3. good one..
    iamharidodda.blogspot.com

    ReplyDelete
  4. Nice it worked fine and specially in my scenario i had to convert dates from one format to anther, so this post really supported me in a very positive manner by saving my lot of time and efforts.......

    ReplyDelete
  5. This worked for me, thanks so much.

    ReplyDelete
  6. Sir i have given below like this. But the time cannot show with AM/PM Format in the Grid. please helpme out.




    ReplyDelete
  7. Sir i have given below like this. But the time cannot show with AM/PM Format in the Grid. please helpme out.




    ReplyDelete