Question

I m试图获得数据表(http://datatables.net),以便与一个协会返回的JsonResult合作。 Net MVC 主计长。我不断收到“可发射警报(表id=实例): 要求从数据来源获得的用于0级“差错”的不为人知的参数0,根据该数字,这意味着它无法找到栏目。

The code in controller that returns the JsonResult looks like:

    public JsonResult LoadPhoneNumbers()
    {
        List<PhoneNumber> phoneNumbers = new List<PhoneNumber>();
        PhoneNumber num1 = new PhoneNumber { Number = "555 123 4567", Description = "George" };
        PhoneNumber num2 = new PhoneNumber { Number = "555 765 4321", Description = "Kevin" };
        PhoneNumber num3 = new PhoneNumber { Number = "555 555 4781", Description = "Sam" };

        phoneNumbers.Add(num1);
        phoneNumbers.Add(num2);
        phoneNumbers.Add(num3);

        return Json(phoneNumbers, JsonRequestBehavior.AllowGet);
    }

电话: C 具有2种特性、编号和说明的组类。

检索和装载数据的java字母如下:

<script>
$(document).ready(function () {
    $( #example ).dataTable({
        "bProcessing": true,
        "sAjaxSource":  /Account/LoadPhoneNumbers/ ,
        "sAjaxDataProp": ""
    });
});
</script>

而html则认为:

<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
<thead>
    <tr>
        <th>
            Number
        </th>
        <th>
            Description
        </th>
    </tr>
</thead>
<tbody>
</tbody>
<tfoot>
</tfoot>
</table>

我故意将SAjaxDataprop定在空洞中,以便数据可点不上aData。即便在我向控制人员明确提出类似要求时:

return Json(new { aaData = phoneNumbers });

我仍然有错误。任何建议都请?

感谢!

Answer 1

对我来说,以下工作是巨大的:

$(function () {
    $( #example ).dataTable({
        bProcessing: true,
        sAjaxSource:  @Url.Action("LoadPhoneNumbers", "Home") 
    });
});

我删除了<条码>sAjaxDataProp。

(a) 收集数据来源:

public ActionResult LoadPhoneNumbers()
{
    return Json(new
    {
        aaData = new[] 
        {
            new [] { "Trident", "Internet Explorer 4.0", "Win 95+", "4", "X" },
            new [] { "Gecko", "Firefox 1.5", "Win 98+ / OSX.2+", "1.8", "A" },
            new [] { "Webkit", "iPod Touch / iPhone", "iPod", "420.1", "A" }
        }
    }, JsonRequestBehavior.AllowGet);
}

仅凭电话:

public ActionResult LoadPhoneNumbers()
{
    var phoneNumbers = new List<PhoneNumber>(new[] 
    {
        new PhoneNumber { Number = "555 123 4567", Description = "George" },
        new PhoneNumber { Number = "555 765 4321", Description = "Kevin" },
        new PhoneNumber { Number = "555 555 4781", Description = "Sam" }
    });

    return Json(new
    {
        aaData = phoneNumbers.Select(x => new[] { x.Number, x.Description })
    }, JsonRequestBehavior.AllowGet);
}

Answer 2

在example 看来,从控制器方法中回收的数据需要具体格式。他实际上把名单作为阿加塔的一部分。报告还解释了每个参数的计算。也许,你不只是以数据表所理解的json格式来安排返回。

public class HomeController : Controller
{
    public ActionResult AjaxHandler(jQueryDataTableParamModel param)
    {
        return Json(new{
                sEcho = param.sEcho,
                iTotalRecords = 97,
                iTotalDisplayRecords = 3,
                aaData = new List<string[]>() {
                    new string[] {"1", "a1", "a2", "a3"},
                    new string[] {"2", "b1", "b2", "b3"},
                    new string[] {"3", "c1", "c2", "c3"}
                    }
            },
        JsonRequestBehavior.AllowGet);
    }
}

友情链接