how to show only date part in gridview in dd-mm-yyyy format

Question

0.00/5 (No votes)

See more:

In grid view I am using dataformatstring{0:dd-MM-yyy}
but it is not working on all forms where i have used it. it is showing correct result on 2-3 pages out 10

Posted 18-Sep-11 22:03pm

Qureshali

Add a Solution

Comments

Prerak Patel 19-Sep-11 4:09am

You are missing a 'y'. Is it a typo? Try {0:dd-MM-yyyy}

Qureshali 19-Sep-11 4:14am

Sorry I have missed a 'y' in question but in my code its dataformatstring{0:dd-MM-yyyy}. But it is not working. Is there any other way of retrieving only date part in dd-mm-yyyy format. Please help me

7 solutions

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)

Anuja Pawar Indore · Answer 1 · 2011-09-18T22:20:00

Solution 1

while binding the grid
use

<%# Eval("startTime", "{0:dd MMM yyyy}")%>

Posted 18-Sep-11 22:20pm

Anuja Pawar Indore

Comments

Anuja Pawar Indore 19-Sep-11 4:24am

<%#Convert.ToDateTime(Eval("StartDate")).ToString("dd MMM yyyy")%>

Member 11054586 4-Dec-14 0:55am

thnkz :)

Anuja Pawar Indore 5-Dec-14 4:09am

Welcome :)

Om Prakash Pant · Answer 2 · 2011-09-18T22:22:00

Solution 2

check the following link for different options:

http://www.c-sharpcorner.com/Forums/Thread/71720/how-to-display-datetime-in-gridview-in-format-mmddyyyy.aspx[^]

Posted 18-Sep-11 22:22pm

Om Prakash Pant

Muralikrishna8811 · Answer 3 · 2011-09-18T22:25:00

Hi,

Use string.split in databinding method in c#

like

C#

res.dt.rows[0][4].tostring().split(" ");

We know already to date format in database is 12-34-1999 12:00:11PM

thn we break that data and time we use date as per our requirement .

And another method is using eval() function in grid view

as I said in earlier.

]]>

I hop you understand what i said.

hitech_s · Answer 4 · 2011-09-18T23:36:00

Solution 4

use this in query where you are getting date field

CONVERT(VARCHAR,date column name,103) as date

sorry if i misunderstand your question

ex:

select column1,column2,CONVERT(VARCHAR,date column name,103) as date from tablename

Posted 18-Sep-11 23:36pm

hitech_s

Updated 18-Sep-11 23:37pm

v2

kanjolia gopal · Answer 5 · 2011-09-19T00:11:00

Solution 5

{0:dd-MM-yyyy}

 You Missed Y in this line

Posted 19-Sep-11 0:11am

kanjolia gopal

Alam Usmani · Answer 6 · 2015-04-05T21:37:00

Solution 6

SQL

set the dataformatstring value to "{0:d}"

Ex:

XML

<asp:BoundField HeaderText="Date" DataField="Date_Field" ReadOnly="True" DataFormatString="{0:d}">
</asp:BoundField>

Posted 5-Apr-15 21:37pm

Alam Usmani

Member 11892236 · Answer 7 · 2015-08-07T01:48:00

C#

XML

<asp:TemplateField HeaderText="DOB">
                                           <ItemTemplate>
                                             <%#Eval("DOB", "{0:dd-MM-yyyy}") %>
                                           </ItemTemplate>
                                       </asp:TemplateField>