I am trying to implement DataGrid contol in Blazor app.
I did not set explicit culture in startup.cs, but looks like visual studio recognise that my threads are in European style of dates dd.MM.yyyy
On razor page with DataGrid I have date column.
Column rendering as regular date format (dd.MM.yyyy) on display,
But if user try to filter date column , browser hit exception.
Same thing hapening in Chorme and Firefox on Win10.
I do not get any exception inside visual studio,
Here is my Razor page Code
@page "/bo"
@inject Services.bo boServis;
@using Models.Bo;
@if (smjene == null)
{
<p><em>UΔitavam...</em></p>
}
else
{
<RadzenGrid AllowFiltering="true" FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive" AllowPaging="true" PageSize="10"
AllowSorting="true"
Data="@smjene"
TItem="Smjene"
ColumnWidth="200px">
<Columns>
<RadzenGridColumn TItem="Smjene" Property="Datum" Title="Datum">
<Template Context="data">
@String.Format("{0:d}", data.Datum)
</Template>
</RadzenGridColumn>
</Columns>
</RadzenGrid>
}
@code {
List<Models.Bo.Smjene> smjene;
protected override async Task OnInitializedAsync()
{
smjene = await boServis.smjene();
}
}
Full Error
blazor.server.js:15 [2019-11-21T14:59:32.564Z] Error: System.FormatException: 20.11.2019 00:00:00 is not a valid value for DateTime.
---> System.FormatException: String '20.11.2019 00:00:00' was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(ReadOnlySpan`1 s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.ComponentModel.DateTimeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
--- End of inner exception stack trace ---
at System.ComponentModel.DateTimeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at System.ComponentModel.TypeConverter.ConvertFromInvariantString(String text)
at System.Linq.Dynamic.Core.Parser.ExpressionParser.GenerateConversion(Expression expr, Type type, Int32 errorPos)
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseTypeAccess(Type type)
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseIdentifier()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParsePrimaryStart()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParsePrimary()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseUnary()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseMultiplicative()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseAdditive()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseShiftOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseComparisonOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseLogicalAndOrOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseIn()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseAndOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseOrOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseLambdaOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseNullCoalescingOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseConditionalOperator()
at System.Linq.Dynamic.Core.Parser.ExpressionParser.Parse(Type resultType, Boolean createParameterCtor)
at System.Linq.Dynamic.Core.DynamicExpressionParser.ParseLambda(ParsingConfig parsingConfig, Boolean createParameterCtor, ParameterExpression[] parameters, Type resultType, String expression, Object[] values)
at System.Linq.Dynamic.Core.DynamicExpressionParser.ParseLambda(ParsingConfig parsingConfig, Boolean createParameterCtor, Type itType, Type resultType, String expression, Object[] values)
at System.Linq.Dynamic.Core.DynamicQueryableExtensions.Where(IQueryable source, ParsingConfig config, String predicate, Object[] args)
at System.Linq.Dynamic.Core.DynamicQueryableExtensions.Where[TSource](IQueryable`1 source, ParsingConfig config, String predicate, Object[] args)
at System.Linq.Dynamic.Core.DynamicQueryableExtensions.Where[TSource](IQueryable`1 source, String predicate, Object[] args)
at Radzen.Blazor.RadzenGrid`1.get_View()
at Radzen.Blazor.RadzenGrid`1.get_PagedView()
at Radzen.Blazor.RadzenGrid`1.BuildRenderTree(RenderTreeBuilder __builder)
at Microsoft.AspNetCore.Components.ComponentBase.<.ctor>b__6_0(RenderTreeBuilder builder)
at Microsoft.AspNetCore.Components.Rendering.ComponentState.RenderIntoBatch(RenderBatchBuilder batchBuilder, RenderFragment renderFragment)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.RenderInExistingBatch(RenderQueueEntry renderQueueEntry)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.ProcessRenderQueue()