Jquery Datatable-Average in footer
Jquery Datatable-Average in footer
我使用jquery数据表显示输出。我有一个例子,我想显示在页脚行的一列的平均值。我怎样才能做到这一点??
请尝试下面的代码来显示数据表插件页脚的平均值:
$('#example').dataTable({
fnFooterCallback: function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
var TotalMarks = 0;
for ( var i=0 ; i<aaData.length ; i++ )
{
TotalMarks += aaData[i][2]*1;
}
var nCells = nRow.getElementsByTagName('th');
nCells[1].innerHTML = TotalMarks/aaData.length;
}
});
我的项目是ASP。Net MVC所以在控制器中我输入一些东西,比如
DataTable dt = GetRequiredData ();双sumField1 = 0;双sumField2 = 0;双avgField1 = 0;
foreach(DataRow r in dt) {sumField1 +=Convert.ToDouble (r (Field1 "));sumField2 + =Convert.ToDouble (r (Field2 "));avgField1 + =Convert.ToDouble (r (Field3 "));}
avgField1/= dt.Rows.Count;
ViewBag.sumField1 = sumField1.ToString ();ViewBag.sumField2 = sumField2.ToString ();
ViewBag.avgField1 = avgField1.ToString ();
然后在View中放入
Sum Field (@Viewbag.sumField1) Sum Field2(@Viewbag.sumField2) Avg字段(@Viewbag.avgField1)
毋庸置疑,这是jQuery数据表的一部分。我老板给我点了赞;)
相关文章:
- Node.js's Buffer.writeFloatBE in Javascript
- Setting default onclick behavior for <img> tag in gene
- Lucene Search in Alfresco
- grep in JQuery to C#
- write HTML in JavaScript
- jQuery setTimeOut: in for-loop
- SetTimeout and clearTimeout in Javascript
- lightbox in html 5 and javascript
- HTMLInputElement in IE7
- Mongodb$in以与数组中相同的顺序获取结果
- element.dataset in Internet Explorer
- jQuery is not defined - WordPress footer.php
- jQuery parent() in table
- Instagram oauth flow in angularjs
- In循环的In运算符前后
- 如何使用for in循环在javascript中显示对象中的对象
- Jquery change onchange in onload
- 重构 jQuery in JS 问题
- strongloop script.js run find in before delete方法:如何同步运行异步方法
- Jquery Datatable-Average in footer