I have a system in asp net mvc, in one of the screens is displayed several items, the select to get them from the bank is:
Select top 20 from Produtos
As shown, it displays only the first twenty products. The products are rendered inside several divs, fed by a foreach. Something like this:
foreach(var itens in produtos){
<div class="col-md-12">
<div class="col-md-6" id="produtos">
@itens.nomeProduto
</div>
</div>
}
But I wanted to bring all the products, and only display twenty, and make a kind of pager in the footer.
The question is, after I bring all the products, how can I get the first 20, and then the next 20, and then the next ones and so on?