Answers

• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  April 2023

  Start by looking at the XHR response in the browser's network inspector. Post a snippet of what you see so we can help offer suggestions. The Ajax docs explain what Datatables expects. You can see running Ajax examples. Click the Ajax tab to see the actual Ajax response.

  Kevin
• markcastrence Posts: 2Questions: 1Answers: 0

  April 2023 edited April 2023

  Hi Kevin, I forgot to mention that the page was already loaded and the call to reload the page to display the json data is from the form on the same page. So nothing is showing in XHR yet. Below is the form. How can I force the page to reload showing the json data in my datatable?

  <div class="row">
          @using (Html.BeginForm("FetchReport", "StoreReport", FormMethod.Post, new { enctype = "multipart/form-data" }))
          {
              <div class="col-4 d-inline-block">
                  <select name="PackageID" asp-for="Package.Id" asp-items="Model.StoreList" class="form-select">
                      <option disabled selected>-- Select Store --</option>
                  </select>
                  <span asp-validation-for="StoreList" class="text-danger"></span>
              </div>
  
              <div class="col-4 d-inline-block">
                  <input type="submit" class="btn btn-primary" value="Fetch Report">
              </div>
          }
      </div>
  
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  April 2023 Answer ✓

  I'm not familiar with the language or framework you are using but the idea is that the web page will contain the JS to initialize Datatables. The ajax option will send a request to the sever to fetch the data. Maybe you need a different URL that just returns the JSON response. Just like the examples I linked to. The page doesn't need to reload to fetch the data.

  Kevin