Numeric filter inputs on RadzenDataGrid use system culture

pr147 · May 4, 2023, 8:25pm

Hi!

I am using the LoadData callback of the RadzenDataGrid including the LoadDataArgs.Filter string and I am experiencing problems when filtering a numeric column with a value with decimal places.

My browser is using the german locale, so I am entering e.g. "1,4" in the filter of a column. In the filter string I would expect that a number is always using the invariant culture "1.4", no matter what locale is used in the browser, but thats not the case. The filter string contains "1,4", which cannot be processed correctly by, e.g., a dynamic LINQ query.

Is this something you could fix?

enchev · May 5, 2023, 12:23pm

You need to set de-DE culture for your application if you want Numeric, DateTime, etc. components to use German culture. Check the commented code in the source code of our demos:

github.com

radzenhq/radzen-blazor/blob/master/RadzenBlazorDemos.Server/Program.cs

using Microsoft.AspNetCore.Components;
using Microsoft.AspNetCore.Components.Web;
using Microsoft.AspNetCore.Hosting.Server;
using Microsoft.AspNetCore.Hosting.Server.Features;
using Radzen;
using RadzenBlazorDemos;
using RadzenBlazorDemos.Data;
using RadzenBlazorDemos.Services;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddRazorPages();
builder.Services.AddServerSideBlazor().AddHubOptions(o =>
{
    o.MaximumReceiveMessageSize = 10 * 1024 * 1024;
});
builder.Services.AddSingleton(sp =>
{
    // Get the address that the app is currently running at

This file has been truncated. show original

UPDATE: Actually I spoke too soon - the problem is different. We need to use ToInvariantString() when creating filter expression for LoadData event args - it will be fixed in our next update next week.

pr147 · May 5, 2023, 6:00pm

Thank you very much!