Save the date in the table and retrieve it ASP.Net Vb.Net

Hi,

<asp:BoundField DataField="Your_DateColumnName" DataFormatString="{0:d}" HtmlRncode="false" />

Select allOpen in new window

Just to explain. It's important to understand, that you do not save a date in some specific format. You apply formatting when you display the date. I.e., a DateTime doesn't have any implicit format, it just date and time components. String representations of a DateTime may have a format. Same is true for SQL server  - it saves date and time components, and how you view them is a different story.

Hi Mr. Lokesh,

This is my code.

  <asp:TemplateField HeaderText="Date" >
                                <HeaderStyle Width="100px" HorizontalAlign="Left" />
                                <ItemStyle Width="100px" HorizontalAlign="Left" />
                                <ItemTemplate>
                                    <asp:Label ID="lblDateClosedID" runat="server" Text='<%#Eval("ID")%>' ItemStyle-HorizontalAlign="Center"  visible="false" ></asp:Label>
                                    <asp:linkbutton ID="lblDateClosed" runat="server" Text='<%#Eval("DateClosed")%>' ItemStyle-HorizontalAlign="Center" CommandName ="EditDate" DataFormatString="{0:d}" HtmlRncode="false" ></asp:linkbutton>
                                </ItemTemplate>
                            </asp:TemplateField>

But it did not make any difference.

or use this in your query

convert(datetime, myDateTimeColumn, 101) as myDateTimeColumn 

Select allOpen in new window

so you get data from sql as "mm/dd/yyyy"

or go to your db and change datatype to date in that table if you really do not need any time part at all!

Thanks. It Worked!!