C# problems loading Data Grid using Datetime

Question

Good night. I have one dataGrid which I carry using Entity Framework, however in dataGrid my date appears MM/dd/yyyy, I want to remove the time and format the date to dd/mm/yyyy, and in the validity field I want to remove only the hour part of the code that generates the dataGrid

Code

using (ConsultorioContext ctx = new ConsultorioContext())
 {
     var lista = ctx.Produtos.ToList();
     return lista;
 }

Datagrid

I tried to change the bank but I still have the same problem.

Answer 1

Change the character of the project Defaltcellstyle.Format to the Custom time and date formatting string "dd/MM/yyyy".

Supposing that your DataGridView be called dataGrid and the time/date column index where you want to apply the formatting 3, the code would be that:

dataGrid.Columns[3].DefaultCellStyle.Format = "dd/MM/yyyy";

EDIT:

As informed that the object is a DataGrid and not DataGridView then the code is:

(dataGrid.Columns[3] as DataGridTextColumn).Binding.StringFormat = "0:dd/MM/yyyy";

or in XAML inside the 'Binding' attribute of the column displaying the date, if it is present, add StringFormat='0:dd/MM/yyyy'.

<DataGrid.Columns>
   <DataGridTextColumn Binding="{StringFormat='0:dd/MM/yyyy'}" />
</DataGrid.Columns>