加载ASP.Net MVC JSONResult jQuery DataTables

我试图让DataTables(http://datatables.net)使用ASP.Net MVC控制器返回的JsonResult.我继续收到一个“DataTables警告(表id =’example’)：从数据源为第0行请求的未知参数’0’错误,根据文档意味着它找不到列.

返回JsonResult的控制器中的代码如下所示：

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);
    }

@H_508_2@phonenumber只是一个普通的C#类,具有2个属性number和Description.

检索和加载数据的javascript如下所示：

<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设置为空字符串,以便DataTables不会查找aaData.即使我在控制器中显式设置aaData：

return Json(new { aaData = phonenumbers });

我仍然收到错误.有什么建议吗

谢谢！

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

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);
}