How to convert datetime to date in c#

Question

1.00/5 (1 vote)

See more:

C#

protected void BindData()
        {
            string strFirstName = "";
            string strLastName="";
            DateTime? dtStartDate = null;
            DateTime? dtEndDate = null;
            var PatientEvaluations = objPatient.GetAllPatientEvaluation(strFirstName,strLastName,dtStartDate,dtEndDate).AsQueryable();

            GridViewPatient.DataSource = PatientEvaluations;
            GridViewPatient.DataBind();
        }

this is my method

in database the start and endDate value is 12/12/1988

but when this method bind into my grid it display

12/12/1988 12:00:00AM

plz help me

i want to display
12/12/1988

Posted 18-Mar-13 4:16am

prince_rumeel

Add a Solution

Comments

ZurdoDev 18-Mar-13 10:23am

You just need to add a dataformatstring to your grid column. Dates are actually a combination of date and time which is why "no time" is actually 12:00 AM.

Sergey Alexandrovich Kryukov 18-Mar-13 10:29am

Right. I answered on time formatting, but did not mention DataFormatString, because OP did not even mention what grid view type is used, etc.
—SA

Matej Hlatky 18-Mar-13 10:27am

Yes because .NET knows only DateTime structure and not Date. Have you tried to use StringFormat = d?

prince_rumeel 18-Mar-13 10:32am

i use this all.but no result

3 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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-03-18T04:24:00

There is no such thing as just date in .NET. However, there is a function Date which returns the same time as argument, with time of the day simply "truncated" to 12:00:00 midnight:
http://msdn.microsoft.com/en-us/library/system.datetime.date.aspx[^].

I believe you don't need it. Your only problem is that you try to show only the date on screen, but the time is also shown. You just need to learn formatting in general, and for this type:
http://msdn.microsoft.com/en-us/library/ht77y576.aspx[^],
http://msdn.microsoft.com/en-us/library/zdtaw1bw.aspx[^],
http://msdn.microsoft.com/en-us/library/8tfzyc64.aspx[^],
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx[^],
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^].

That's it.

—SA

prince_rumeel · Answer 2 · 2013-03-18T05:08:00

Solution 6

HTML

<div class="right" style="width: 166px; height: 19px;">
                                        <%# Eval("EvaluationDate", "{0:M-dd-yyyy}")%></div>

i solve it using this in my grid view

Posted 18-Mar-13 5:08am

prince_rumeel

**NAGARAJ N MACHAKNUR** · Answer 3 · 2013-03-18T04:24:00

C#

protected void BindData()
        {
            string strFirstName = "";
            string strLastName="";
            DateTime? dtStartDate = null;
            DateTime? dtEndDate = null;
            var PatientEvaluations = objPatient.GetAllPatientEvaluation(strFirstName,strLastName,dtStartDate.ToString("dd/MM/yyyy"),dtEndDate.ToString("dd/MM/yyyy")).AsQueryable();

            GridViewPatient.DataSource = PatientEvaluations;
            GridViewPatient.DataBind();
        }

You try this, hope it will give expected result what you needed.

How to convert datetime to date in c#

3 solutions

Solution 2

Solution 6

Solution 1

Add your solution here

Preview 0