Webgrid Format of datetime and setting style

Question

I'm struggline with syntax gremlins with the WebGrid. In my normal razor markup i format a date inside my foreach like so

<td>
        @String.Format("{0:MM/dd/yy hh:mm:ss}", item.complianceedatetime)
    </td>

and I set my column width like so

<th width="150px">
        Download Date/Time
    </th>

How would I do this with the Grid.Column syntax

grid.Column("complianceedatetime", "Download Date/Time", ?, ?)

score 8 · Answer 1 · answered Aug 28 '11 at 15:06

8

@grid.GetHtml(
    column: grid.Columns(
              grid.Column("Complianceedatetime", "Download Date / Time", 
format: @<text>@item.complianceedatetime.ToString("MM/dd/yy hh:mm:ss")</text>)
            )
)

I know this works because I have this exact code in my project:

grid.Column(
            "PublishDate",
            canSort: true,
            format: @<text>@item.PublishDate.ToString("MM/dd/yyyy")</text>
        ),

answered Aug 28 '11 at 15:06

wtjones

4,090
4
34
41

Changing `@item.complianceedatetime` to `@item.Complianceedatetime` would make the top snippet work properly. Otherwise, the second code snippet works. – Tim Hobbs Dec 10 '11 at 01:43

score 4 · Answer 2 · edited Oct 03 '12 at 17:22

If DateTime Property is defined as (can contain null):

public DateTime? WorkedDate { get; set; }

Use this format:

grid.Column("WorkedDate", "Last Worked On",
   format: (item) => item.WorkedDate != null 
   ? item.WorkedDate.ToString("MM/dd/yy") : "", canSort: true)

Otherwise if it is defined as below (can't be null), it will have either actual date or .MinDate as the default.

public DateTime WorkedDate { get; set; }

Use format:

grid.Column("WorkedDate", "Last Worked On",
   format: (item) => item.WorkedDate != DateTime.MinValue ? 
   item.WorkedDate.ToString("MM/dd/yy") : "", canSort: true)

Nandu · Answer 3 · 2012-02-10T03:19:27.317

1

You could try this:

@grid.GetHtml(
    column: grid.Columns(
              grid.Column("Complianceedatetime", "Download Date / Time", format: (item) => string.Format("{0:MM/dd/yy hh:mm:ss}", item.complianceedatetime)
            )
)

edited Feb 10 '12 at 03:19

answered Apr 14 '11 at 05:06

Nandu

38
4

score 0 · Answer 4 · answered May 16 '11 at 15:43

0

Try this option for better globalization

    @grid.GetHtml(
        column: grid.Columns(
                  grid.Column("Complianceedatetime", "Download Date / Time", 
                  format: @@String.Format("{0:g}",complianceedatetime))
                )
    )

answered May 16 '11 at 15:43

Hemant

411
4
15

1

This doesn't work either. People, check your code please. It takes a minute to run it. It would really help for those of us trying to understand and learn the syntax if you would make sure you are posting correct code. – Chris Holmes Jul 19 '11 at 04:32

Webgrid Format of datetime and setting style

4 Answers4