I'm setting the grid datasource with ajax call to the controller JsonResult action which returns
new CustomJsonResultNoDateHour { Data = PolLista.ToList() };
because of the date fields.
Internal class is like this:
internal class CustomJsonResultNoDateHour : JsonResult
{
private const string _dateFormat = "yyyy-MM-dd";
public override void ExecuteResult(ControllerContext context)
{
if (context == null)
{
throw new ArgumentNullException("context");
}
HttpResponseBase response = context.HttpContext.Response;
if (!String.IsNullOrEmpty(ContentType))
{
response.ContentType = ContentType;
}
else
{
response.ContentType = "application/json";
}
if (ContentEncoding != null)
{
response.ContentEncoding = ContentEncoding;
}
if (Data != null)
{
var isoConvert = new IsoDateTimeConverter();
isoConvert.DateTimeFormat = _dateFormat;
response.Write(JsonConvert.SerializeObject(Data, isoConvert));
}
}
}
But how can I change the format in the grid column? If I set it like this:
col.Field("DatumOd").HeaderText("Početak").Format("{0:dd.MM.yyyy.}").Width(100).Add();
it's still displays
but if I export it to the excel...I got this:
So, the export format is OK, but the display in the column is not.
If I change the format in the internal class to this:
private const string _dateFormat = "yyyy-MM-dd";
then th display in the grid is OK, but when I want to export it to excel,
the error says "the value 19.02.2019. is not valid for the datetime".
Any idea how to handle this?
Thanks.
Bernard.
