Blazor + Syncfusion + Dapper: Part 4 - Adding a Syncfusion DataGrid

Create a C# Blazor application using Syncfusion controls and Dapper to illustrate a one-to-many relationship (master/detail pages). This video shows the addition of a Syncfusion DataGrid to the index page, together with enhancements to allow filtering, sorting and resizing of columns. The context menu feature of the DataGrid is also explained, including how to export the data from the DataGrid to Excel or in csv format.
Full description and documentation for the project at: blazorcode.uk/...
Documentation & code for this video: blazorcode.uk/...
Syncfusion: www.syncfusion...
Background: Alan Simpson's Blazor CRUD videos: www.youtube.co....

[@DigitalNomadOnFIRE]

Please make clear if this is Server or WA early and often specially in title.
Thx

[@pangolinkk]

Nice, Thank You!

[@christopherbell7186]

Thank you! The next video should be coming along shortly...

[@coolwaterdvr]

I went back to this tutorial for the Excel Export. For new version of syncfusion 20.0+ we need to edit the service (services.AddSyncfusionBlazor(options => { options.IgnoreScriptIsolation = false; });) to make the context menu and toolbar to work.

[@christopherbell7186]

Thank you for the update. I guess this is an example of the dangers of using external libraries!

[@coolwaterdvr]

@@christopherbell7186 I will assume this will no longer be an issue when .net 6.0 will be officially released.

[@jamesscott6864]

I get this error when i build and run the program:
System.FormatException: 'Could not parse the JSON file.'
an exception thrown in program.cs

[@christopherbell7186]

When you created the project in C# some files were created automatically, one of them was appsettings.json. It sounds to me as if this is not formatted correctly. Have a look at blazorcode.uk/countriesandcities/sql-connection/ in particular have a look at the screenshots at the end of the post and compare with yours.

[@jamesscott6864]

Okay i found why i had a run-time error. there was a comma missing in the appsettings.json file

[@christopherbell7186]

Well done!