首页 > 解决方案 > 尝试使用 Json 从数据库中获取数据并将其显示在 handsontable 中。该表未正确显示数据

问题描述

        This is the code for fetching the data from database using Json and displaying it in handsontable. I checked in console and it shows the data I am getting from database but somehow that data is not being displayed in handsontable.
        ```


<div id="example"></div>
    <script type="text/javascript">          
    const container = document.getElementById('example');
    var hot = new Handsontable(container, {
    //  data: getData(),               
        rowHeaders: true,
        colHeaders: true,                
        licenseKey: 'non-commercial-and-evaluation',
        colHeaders: true
        });               

    $(document).ready(function () {  
                var result = null;
                $.ajax({
                        url: 'someurl',
                        type: 'post',
                        dataType: 'json',
                        async: false,
                        success: function (res) {
                        result = res;                             
                        },
                        error: function (XMLHttpRequest, textStatus, errorThrown) {
                                alert("Status: " + textStatus); alert("Error: " + errorThrown);                            
                            }
                        });
              console.log(result);
              var resultdata = JSON.parse(JSON.stringify(result));
              hot.loadData(resultdata);
    });
    </script>

这是来自控制器的代码,它从数据库中获取数据并返回它。我不知道我返回的数据类型是否正确,或者返回的数据是否需要序列化。谁能帮我这个?我将非常感谢任何人的任何帮助

     public class SupplierTypeController : BaseController
        {
            [HttpGet]
            public JsonResult Index()
            {
          IEnumerable<SupplierTypeDto> supplierType = new List<SupplierTypeDto>();
                var apiResponse = Post<List<SupplierTypeDto>>("api/SupplierType/SuppliersType", null);

                if (apiResponse != null)
                {
                    if (apiResponse.Success)
                    {
                        supplierType = apiResponse.Data;

                    }

                }
                else
                {
                    ShowErrorMesage(ResponseMessages.API_NoResponse);
                }

                return Json(supplierType,JsonRequestBehavior.AllowGet);
            }

          }

标签: javascriptasp.netjsonrazorhandsontable

解决方案


推荐阅读