sql - Creating a dasboard-esque page for viewing data

Question

I'm currently working on a web app using .NET Core and Razor pages. So after getting the CRUD elements pretty much sorted, the final part for me is to create a page so they can view their main data.

At the moment, their requirements for searching data would be by person and / or by project.

My initial plan is to give them two drop downs containing each of these data. And when they're happy to start the search, press a button and a SP will retrieve the data from the data base.

The bit I need help with is displaying the data. Before I was using fairly standard HTML tables in the page.

However now that the data will be refreshed and will be different based on the search parameters I'm not too sure on how to implement this.

The only way I can think of doing this is to create a API to get the data back from the DB in a JSON format and then use JavaScript functions, possibly including the data tables plugin.

Any help or suggestions would be much appreciated.

Thank you

标签： sqlasp.net-corerazor-pages