Roman
Roman

Reputation: 21

Converting Datatable to PagedList to show in razor pages C#

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

Answers (0)

Related Questions