To display only date from datetime type

Question

0.00/5 (No votes)

See more:

hi frnds,
In my application,i m using a gridview which fetches value from racle database,there is a linkbutton where when the user clicks on it..a pop up msg pops up...now...in the gridview there is a coumn called start date of type datetime..in the pop up msg the user can edit this start date..i m getting the start date value from the grid view using query strings...now..i just wanna display the date and not the time in the pop up msg.

textbox.text=strings[3];

is the statement i m using,where string[3] is the value containing...11/2/2012 12:00 am.
Now,
i want textbox.text to have oly 11/2/2012.
how do i do??
pls help
thanks

Posted 12-Jan-12 17:04pm

Member 8459400

Updated 12-Jan-12 19:03pm

Prasad_Kulkarni

v2

Add a Solution

9 solutions

Solution 3

check these blogs
http://www.daniweb.com/software-development/csharp/threads/127457[^]
http://www.codeguru.com/forum/showthread.php?t=353407[^]
--NDK

Posted 12-Jan-12 18:43pm

NandaKumer

Solution 2

Try DateTime dateOnly = date.Date;

Posted 12-Jan-12 17:44pm

Abhinav S

Solution 4

try this way
in template of grid

XML

<asp:Label id="Label1" runat="server" Text='<%# Eval("CreationDate", "{0:M-dd-yyyy}") %>'>
    </asp:Label>

or refer this link for more details
http://peterkellner.net/2006/05/24/how-to-set-a-date-format-in-gridview-using-aspnet-20using-htmlencode-property/[^]

Posted 12-Jan-12 18:52pm

P.Salini

Solution 5

You should use DataFormatString Parameter in Grid View

ASP.NET

<asp:BoundField DataField="DateColumn" DataFormatString="{0:dd/mm/yyyy}" />

and you can assign this value directly to textbox

Posted 12-Jan-12 18:54pm

Technoses

Updated 12-Jan-12 18:55pm

v2

Comments

Technoses 13-Jan-12 0:58am

If solve please rate this as your solution

Solution 6

You can set the datetime format in Gridview in following way,

XML

<asp:BoundField DataField="HDate" DataFormatString="{0:dd'/'MM'/'yyyy}" HeaderText="Date"
HtmlEncode="False" SortExpression="HDate">
</asp:BoundField>

Posted 12-Jan-12 19:04pm

Supriya Srivastav

Comments

tianyacao8025 13-Jan-12 2:14am

using format as {0:dd'/'MM'/'yyyy} is ok

Solution 7

Hi,
Check this once: Complete List Of Date-Time Formats

Posted 12-Jan-12 19:06pm

Prasad_Kulkarni

Solution 9

use below

<asp id="Label1" runat="server" label.text="<%# Convert.Todate(Eval("date")).toShortDateString() %>"></asp>

Posted 12-Jan-12 22:16pm

Nigam Patel

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

member60 · Accepted Answer · 2012-01-12T17:26:00

Solution 1

C#

<asp id="Label1"  runat="server" Label.Text='<%# Eval("date", "{0:M-dd-yyyy}") %>'>

Posted 12-Jan-12 17:26pm

member60

Updated 12-Jan-12 19:02pm

v3

Comments

Member 8459400 13-Jan-12 0:11am

thanks for replying..from the database i m getting data as 12/2/2011...now i have to show only 12/2/2011 in the gridview..how do i show?

member60 13-Jan-12 0:59am

while binding the date fields from database try to foramt it as:
Eval("date", "{0:dd/MM/yyyy}")
where "date" is the database column you want to bind
or see my improved solution:

Member 8459400 13-Jan-12 5:16am

thank u so much :) it worked...

Omkar Hendre 1-Aug-14 2:08am

thank you it works for me thank you very much sir

tianyacao8025 · Accepted Answer · 2012-01-12T20:13:00

Solution 8

using format as {0:dd'/'MM'/'yyyy} is ok

Posted 12-Jan-12 20:13pm

tianyacao8025