DataTables warning (table id = 'myTable'): Requested unknown parameter '0' from the data source for row 0

第一种方式：不用在js里设置列
Html：

<table id="myTable">
        <thead>
            <tr>
                <th>Title-1</th>
                <th>Title-2</th>
                <th>Title-3</th>
                <th>Title-4</th>
                <th>Title-5</th>
                <th>Title-6</th>
                <th>Title-7</th>
                <th>Title-8</th>
                <th>Title-9</th>
                <th>Title-10</th>
                <th>Title-11</th>
                <th>Title-12</th>
                ......
            </tr>
        </thead>
        <tbody></tbody>
 </table>

Javascript:

<script type="text/javascript">
    $(function () {
        $('#myTable').dataTable({
            "bServerSide": true,
            "sAjaxSource": "/Home/TodaySO",
            "bPaginage": true,
            "sPaginationType": "full_numbers",
            "iDisplayLength": 5,
            "oLanguage": { "sUrl": "/Scripts/DataTable/dataTable_cn.txt" }//多语言配置

　　　　　　//注意这里没有配置列的信息！

        });//end table
    });//end ready()
</script>

Controller：

var result = from f in filteredData.OrderBy(o => o.SalesOrder)
                .Skip(param.iDisplayStart)
                .Take(param.iDisplayLength)
                .ToList()
            select new[]{ f.Field-1, f.Field-2, f.Field-3, f.Field-4, f.Field-5, f.Field-6, f.Field-7, f.Field-8, f.Field-9, f.Field-10, f.Field-11, f.Field-12  
　　　　　　　　　　　　　　......  
            };

---------------FireBug------------

数组格式：

{"sEcho":"1","iTotalRecords":2210,"iTotalDisplayRecords":2210,
    "aaData":[
        ["3004582952","10  "],
        ["3004582952","100 "],
        ["3004582952","20  "],
        ["3004582952","30  "],
        ["3004582952","40  "]
    ]
}

第二种方式：要在js里设置列
Html：

 <table id="myTable">
    <thead>
       <tr>
            <th>Title-1</th>
            <th>Title-2</th>
            <th>Title-3</th>
            <th>Title-4</th>
            <th>Title-5</th>
            <th>Title-6</th>
            <th>Title-7</th>
            <th>Title-8</th>
            <th>Title-9</th>
            <th>Title-10</th>
            <th>Title-11</th>
            <th>Title-12</th>
            ......
        </tr>
    </thead>
    <tbody></tbody>
</table>

Javascript：

<script type="text/javascript">
    $(function () {
        $('#myTable').dataTable({
            "bServerSide": true,
            "sAjaxSource": "/Home/TodaySO",
            "bPaginage": true,
            "sPaginationType": "full_numbers",
            "iDisplayLength": 5,
            "oLanguage": { "sUrl": "/Scripts/DataTable/dataTable_cn.txt" },//多语言配置
            "aoColumns": [ { "mData": "Field-1" }, { "mData": "Field-2" }, { "mData": "Field-3" }, { "mData": "Field-4" } , { "mData": "Field-5" } , { "mData": "Field-6" } , { "mData": "Field-7" } , { "mData": "Field-8" } , { "mData": "Field-9" } , { "mData": "Field-10" } , { "mData": "Field-11" } , { "mData": "Field-12" } ......
            ]
        });//end table
    });//end ready()
</script>

Controller:

 var result = from f in filteredData
                  .OrderBy(o => o.SalesOrder)
                  .Skip(param.iDisplayStart)
                  .Take(param.iDisplayLength)
               select f;

---------------FireBug------------

Javascript对象格式：

{
    "sEcho":"1",
    "iTotalRecords":2210,
    "iTotalDisplayRecords":2210,
    "aaData":[
        {"SalesOrder":"3004582952","SalesOrderItem":"10  ","CustomerPO":"SEG131800",...},
        {"SalesOrder":"3004582952","SalesOrderItem":"100 ","CustomerPO":"SEG131801",...},
        {"SalesOrder":"3004582952","SalesOrderItem":"20  ","CustomerPO":"SEG131802",...},
        {"SalesOrder":"3004582952","SalesOrderItem":"30  ","CustomerPO":"SEG131803",...},
        {"SalesOrder":"3004582952","SalesOrderItem":"40  ","CustomerPO":"SEG131804",...}
    ]
}