ASP.NET Core Web App - Looping through a DataTable

Question

Hello All,

I am creating an ASP.NET Core Web App using C# using .NET6.0. I have only just started and looking to complete a connection to an existing SQL database and just quickly display some data to prove the connection and the SQL Queries.

This is my setup; I have only created one page so far: ‘dashboard.cshtml’

The SQL query works fine and, when stepping through the code, returns the expected values from the database as you can see below:

I also added a string variable to see if this would display and also to test the display of a single variable in the front end. As you can see the expected value is assigned

However, as you can see from the images above, there is a problem with the reference to the variables ‘message’ and ‘dtsensors’ in the html and so the application does not run. The errors are below:

So, could anyone help me to understand what the error message ‘the name <variable> does not exist in the current context’? And how to fix it? Also, could some one confirm how I loop through a DataTable in the front end? I cannot find any documentation on this.

Thanks in advance

Answer 1

Hi @Chris Undritz ,

Razor exposes a Model property for accessing the model passed to the view, so you can access the properties via the @Model.{PropertyName}, refer to the following screenshot:

More detail information about Razor syntax, see Razor syntax reference for ASP.NET Core.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,
Dillion

Answer 2

So I have managed to put in place a solution. I loop through the datatable in the C# code to create a sensor class data object and I am able to loop through that in the front end. Management seem happy enough with this so result!