DateTime convert to shortdatetime in grid

Question

How can I convert the selected dates to shortdate types in my grid? I only wanna show the dates and not time.

vasketidssystemEntities forbindelse = new vasketidssystemEntities();

    public OwnReservations()
    {
        InitializeComponent();
    }
    private void Grid_Loaded(object sender, RoutedEventArgs e)
    {
            ObjectQuery<reservation> reservationer = forbindelse.reservations;

            var query =
            from res in reservationer
            where res.resident_ID == 17
            orderby res.date
            select new { res.date, res.hourofday, res.resident_ID };

           datagrid1.ItemsSource = query.ToList();

score 2 · Accepted Answer · edited May 23 '17 at 12:12

2

You can edit the column format for that column you want to format, like so:

datagrid1.Columns[0].DefaultCellStyle.Format = "d";

Do this after you have set the ItemsSource of the datagrid1.

source

edited May 23 '17 at 12:12

Community

1
1

answered Dec 16 '14 at 14:14

Adrian Nasui

1,054
9
10

score 0 · Answer 2 · edited May 23 '17 at 12:05

You can do something like the answer found in this SO question, namely:

reservationer.Select(a => new { a.date, a.hourofday, a.resident_ID })
                         .AsEnumerable()
                         .Select(p => new 
                                { date = p.date.ToShortDateString(),
                                  hourofday = p.hourofday,
                                  resident_ID = p.resident_ID
                                });

DateTime convert to shortdatetime in grid

2 Answers2