Reputation: 21
I have a datatable to show in my View.But I need to show it as a paged list in view.What is the easiest solution for that.
My controller:
DataTable dataTable = new DataTable();
using (SqlConnection sqlConnection = new SqlConnection(_configuration.GetConnectionString("DevConnection")))
{
sqlConnection.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("AllStory", sqlConnection);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.Fill(dataTable);
}
if(dataTable.Rows.Count>0)
{
var newTable = dataTable.AsEnumerable().OrderByDescending(r => r.Field<DateTime>("Date")).CopyToDataTable();
return View(newTable);
}
else
{
return View(dataTable);
}
My View :
@for (int i = 0; i < Model.Rows.Count; i++)
{
<div class="row">@Model.Rows[i]["Title"]</div>
<div class="row">
@Model.Rows[i]["Author"] @Model.Rows[i]["date"]
<div>
<div>@Model.Rows[i]["Body"]</div>
</div>
</div
</div>
}
Upvotes: 0
Views: 201