我使用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数据表的一部分。我老板给我点了赞;)