i want to display only date but in my code it display date a

i want to display only date but in my code it display date and time both how to do this.

i want to display "01-01-1900" only but same are display

"01-01-1900 00:00:00" how to remove time.

.aspx

<%@ Page Language="C#" AutoEventWireup="true" Codefile="GeneReport.aspx.cs" Inherits="ContractCloser1.GeneReport" %>
"http://www.w3.org/1999/xhtml">
"viewport" content="width=device-width, initial-scale=1">
"text/css">
.auto-style1 {
font-weight: bold;
text-decoration: underline;
}
.auto-style2 {
text-decoration: underline;
}
"style1">
5>
"margin-left:5px; width: 564px; height: 400px;"
"Arial" size="6">"auto-style2" />"auto-style2" />
"auto-style1">
black size=6>Generate Department LOA Details1>
"form1" runat="server">
"style1">
"Arial" size="4">
"margin-left: 0px; width: 566px; height: 195px;" class="auto-style1">
"auto-style2">
Select Department
"DropDownList1" runat="server">
"Button1" runat="server" Text="GetData" OnClick="Button1_Click1" Style="height: 26px" />

"GridView1" runat="server" BackColor="black" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" Width="561px" style="text-align: center">
"" />
"#CCCCCC" ForeColor="Black" />
"#000084" Font-Bold="True" ForeColor="White" />
"#999999" ForeColor="Black" HorizontalAlign="Center" />
"#EEEEEE" ForeColor="Black" />
"#008A8C" Font-Bold="True" ForeColor="White" />
"#F1F1F1" />
"#0000A9" />
"#CAC9C9" />
"#000065" />

3 Replies
Know the answer? Post it — somebody with the same question will find it here.

Sonu Gupta7y ago
Hi Indradeo,

Use the ToShortDateString(). Like this

public static void Main()

{

DateTime dt =new DateTime();

Console.WriteLine(dt.ToShortDateString());

}
Amit Mohanty7y ago
Hey use asp:BoundField to bind data to gridview and set these belew properties of the date column
DataFormatString = ({0:d})
ApplyFormatInEditMode = True
Ex:
"GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
    DataSourceID="SqlDataSource" ShowHeaderWhenEmpty="True" EnableViewState="False">

        "DATA_DATE" HeaderText="Snapshot Date" ApplyFormatInEditMode = True
            SortExpression="DATA_DATE" DataFormatString="{0:d}"  />
Rajanikant Hawaldar7y ago
Hi Dear,

you can change date formate at query, refer below thread, ask me if you want any information on this.
https://www.mssqltips.com/sqlservertip/2655/format-sql-server-dates-with-format-function/