Radzen Data Grid Export - Columns beginning with numbers

Radzen.Blazor Components
1

Hi there, I've got columns beginning with a number (e.g. 30_bananas) in my Radzen Data Grid. I'm using the built in export functionality which creates the select part of the query like this:
var select = string.Join(",", grid0.ColumnsCollection.Where(c => c.GetVisible() && !string.IsNullOrEmpty(c.Property)).Select(c => c.Property.Contains(".") ? c.Property + " as " + c.Title.Replace(".", "").Replace(" ", "_") : c.Property + " as " + c.Title.Replace(".", "").Replace(" ", "_")));

But this causes the export to stop working, as an error occurs in the ApplyQuery function in the ExportController:
return items.Select($"new ({query["$select"].ToString()})");

Any ideas?

2
3

Not sure how that helps? If my column is 30bananas, it will still break when I try to export.


columns = new Dictionary<string, Type>()
        {
            { "30bananas", typeof(int?) }
}

In C#, you can't have variable names that start with a number. Hence this breaks in the export controller:
return items.Select($"new ({query["$select"].ToString()})");

4

Yes, this is a case which is not supported out of the box. You should specify an alias (via ‘as’) so your columns are valid C# identifiers. The other option is to modify the export controller.

5

Thanks. I know it's a minor issue, but maybe you could consider this in your next release and modify the export controller so it works. :slight_smile: