How to use foreach loop with a where clause

December 11 2020 by Admin

In this article, we have described how to use a foreach loop with a where clause with an example and sample code.

In this article, we have described how to use a foreach loop with a where clause with an example and sample code. We are binding the table in view using foreach loop .

Step -1

Open Visual Studio. Click on the file in the menu and select new Project .

How to use foreach loop with a where clause

Step -2

Select new project type.

Index.cshtml

We have provided html code below.

@model List<WebApplication1.Models.Stockmodel>

Layout = null;

}

<html>

<head>

<title>foreach loop with a where clause.</title>

</head>

<body>

<div>

<tr>

</tr>

@*Parent Id =0*@

@foreach (var stock in Model.Where(x=>x.ParentId==0))

{

<tr>

<td>@stock.stockId</td>

<td>@stock.StockName</td>

</tr>

}

</table>

</div>

</body>

</html>

Model

public class Stockmodel

{

public Int32 stockId { get; set; }

public Int32 ParentId { get; set; }

public string StockName { get; set; }

public decimal StockPrice { get; set; }

}

StockController

public class HomeController : Controller

{

[HttpGet]

public ActionResult dashboard()

{

List<Stockmodel> stocks = new List<Stockmodel>();

stocks.Add(new Stockmodel

{

stockId = 1,

ParentId = 1,

StockName = "REL",

StockPrice = Convert.ToDecimal(2000.00)

});

stocks.Add(new Stockmodel

{

stockId = 2,

ParentId = 0,

StockName = "Infosys",

StockPrice = Convert.ToDecimal(1100.00)

});

stocks.Add(new Stockmodel

{

stockId = 3,

ParentId = 0,

StockName = "TCS",

StockPrice = Convert.ToDecimal(2800.00)

});

stocks.Add(new Stockmodel

{

stockId = 4,

ParentId = 1,

StockName = "Bajaj Finance",

StockPrice = Convert.ToDecimal(4800.00)

});

return View(stocks);

}

Table
MVC

Home > MVC > How to use foreach loop with a where clause