Error when displaying all records on 1 page by Page_Render

ASP.NET Maker General Discussion (ASP.NET Maker)
1

SQLite DB and trial 2020.0.2
The key and the tables are OK.I have a page with

public void Page_Render() {
//Log(“Page Render”);
StartRecord = 1;
DisplayRecords = TotalRecords;
}De page crashes every time the totalrecords is +25. The display of the page is correct if totalrecords not exceed 25.There is no problem with the 2018 version and MS Access.An unhandled exception occurred while processing the request.
KeyNotFoundException: The given key ‘Lid_ID’ was not present in the dictionary.
System.Collections.Generic.Dictionary<TKey, TValue>.get_Item(TKey key)
o AspNetMaker2020.Models.VZP_Proj_2020+_Provisie_ListBase.LoadRowValues(DbDataReader dr) in Provisielist.cs

  1. Lid_ID.SetDbValue(row[“Lid_ID”]);
    o AspNetCore.Views_Home_Provisielist.b__17_1() in Provisielist.cshtml
  2. await Provisie_List.LoadRowValues(Provisie_List.Recordset); // Load row values
    …

If I remove

public void Page_Render() {
//Log(“Page Render”);
StartRecord = 1;
DisplayRecords = TotalRecords;
}
AND
If I set ASP.NET>PageOptions(global)>records per page to for instance 50 then all records for a given ‘Lid_ID’ are displayed (1 page)
OR
If I set ASP.NET>PageOptions(global)>records per page to for instance 25 then all records for a given ‘Lid_ID’ are displayed (more pages)But if for instance I set PageOptions(global)>records per page to 25 AND to show all records on 1 page withpublic void Page_Render() {
//Log(“Page Render”);
StartRecord = 1;
DisplayRecords = TotalRecords;
}then the page crashes for every ‘Lid_ID’ with more records than 25 records.Regards,
Dirk Vandenbossche

2

If you change the number of display records in Page_Render, you probably need to load the recordset again:Recordset = LoadRecordset(StartRecord - 1, DisplayRecords).GetAwaiter().GetResult();