how to show ToShortDateString() in my query

Question

1.00/5 (1 vote)

See more:

hi,
i have my function BindGrid(), i have attribute dsm in my database i have 2010-01-01 00:00:00.000 and i want to display just 2010-01-01 i have add q.DATE_MS.Value.ToShortDateString() but it dosen't work

pzz help mee

C#

void BindGrid()
       {
           using (QTEL_Entities qtl = new QTEL_Entities())
           {
               var rslt = from q in qtl.STATIONs
                          select new
                          {
                              id=q.ID_STATION,
                              lib=q.LIBELE_STATION,
                              typ=q.TYPE_STATION,
                              dsm=q.DATE_MS.ToString(), // 
                             
                          }
                          ;
               gridSample.DataSource = rslt.ToList();
               gridSample.DataBind();
           }
       }

Posted 7-Jul-15 2:34am

Member 11573837

Updated 15-Jun-16 21:05pm

Add a Solution

Comments

Kornfeld Eliyahu Peter 7-Jul-15 8:53am

"it dosen't work" - what do you mean by that? Error? Unexpected result?

Suvendu Shekhar Giri 7-Jul-15 9:00am

Try-
DATE_MS.ToString("yyyy-MM-dd");

Member 11573837 7-Jul-15 9:08am

hi Kornfeld Eliyahu Peter,
thank you to answering me i have exception (LINQ to Entities does not recognize the method 'System.String ToShortDateString()' method, and this method cannot be translated into a store expression.)

Member 11573837 7-Jul-15 9:11am

hi Suvendu Shekhar Giri,
you solution not work i have red underling
(no overloading for methde tostring)

3 solutions

Solution 3

You cannot put a method call into the LINQ query that the provider cannot translate into SQL. So, you cannot use .ToString().

The quick'n'dirty solution is to retrieve the objects, convert it to a list so the query executes against the database and then create your view objects from the list, putting the .ToString() call in that code instead.

C#

void BindGrid()
{
    using (QTEL_Entities qtl = new QTEL_Entities())
    {
        // Grab the data from the database.
        var dataItems = qtl.STATIONs.ToList();

        // Create view model objects from the data.
        var rslt = from item in dataItems
                   select new
                   {
                       id=q.ID_STATION,
                       lib=q.LIBELE_STATION,
                       typ=q.TYPE_STATION,
                       dsm=q.DATE_MS.ToString("yyyy-MM-dd")
                   };
               gridSample.DataSource = rslt.ToList();
               gridSample.DataBind();
           }
}

Posted 7-Jul-15 4:58am

Dave Kreskowiak

Comments

Richard Deeming 7-Jul-15 11:14am

You can avoid creating two copies of the data by replacing the first .ToList() call with .AsEnumerable().

Dave Kreskowiak 7-Jul-15 11:16am

Forgot about that one. I did say quick'n'dirty, didn't I? :)

Member 11573837 7-Jul-15 11:18am

hi Dave Kreskowiak,
i have use your solution but it dosen't work for mee i i swear

Dave Kreskowiak 7-Jul-15 11:24am

"Doesn't work" is not descriptive of the problem. What DOES happen?

Member 11573837 7-Jul-15 11:19am

hi, Richard Deeming
plz how can i do can you give me example plz

Member 11573837 7-Jul-15 11:39am

http://www.mediafire.com/view/3w2hu9jmi784smp/img_code.png

Dave Kreskowiak 7-Jul-15 11:45am

Screen shots don't work and don't last as long as this forum will. MediaFire is blocked where I'm at.

Either type up the description or you're on your own.

Richard Deeming 7-Jul-15 12:09pm

Guessing at a translation of the error message (which you should have pasted as text instead of a screen-shot):
"No overload for method 'ToString' takes 1 arguments"

At a guess, DATE_MS is declared as a Nullable<DateTime> (aka DateTime?).

Try:
dms = string.Format("{0:yyyy-MM-dd}", q.DATE_MS)

Member 11573837 7-Jul-15 12:18pm

thank you Richard Deeming,
i solve my problem
var rslt = (from q in qtl.STATIONs
select new
{
id=q.ID_STATION,
lib=q.LIBELE_STATION,
typ=q.TYPE_STATION,
dsm=q.DATE_MS
}).ToList().Select(x => new
{
id=x.id,
lib=x.lib,
typ=x.typ,
dsm=string.Format("{0:yyyy-MM-dd}", x.dsm),
});

Solution 2

void BindGrid()
       {
           using (QTEL_Entities qtl = new QTEL_Entities())
           {
               var rslt = (from q in qtl.STATIONs
                          select new
                          {
                              id=q.ID_STATION,
                              lib=q.LIBELE_STATION,
                              typ=q.TYPE_STATION,
                              dsm=q.DATE_MS 
                          }).ToList().Select(x => new
                         {
                              id=x.id,
                              lib=x.lib,
                              typ=x.typ,
                              dsm=string.Format("{0:yyyy-MM-dd}", x.dsm), 
                         });
               gridSample.DataSource = rslt.ToList();
               gridSample.DataBind();
           }
       }

Posted 7-Jul-15 3:15am

Anil Vaghasiya

Updated 13-Jul-15 20:02pm

v3

Comments

Member 11573837 7-Jul-15 9:18am

hi Anil Vaghasiya, i try it and it dosen't work

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)

Animesh Datta · Accepted Answer · 2015-07-07T05:29:00

Hello,
Try this way

void BindGrid()
       {
           using (QTEL_Entities qtl = new QTEL_Entities())
           {
               var rslt = (from q in qtl.STATIONs
                          select new
                          {
                              id=q.ID_STATION,
                              lib=q.LIBELE_STATION,
                              typ=q.TYPE_STATION,
                              dsm=q.DATE_MS 
                          }).ToList().Select(x => new
                         {
                              id=x.id,
                              lib=x.lib,
                              typ=x.typ,
                              dsm=string.Format("{0:yyyy-MM-dd}", x.dsm), 
                         });
                          
               gridSample.DataSource = rslt.ToList();
               gridSample.DataBind();
           }
       }

thanks

how to show ToShortDateString() in my query

3 solutions

Solution 4

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us