Telerik grid: retrieve row count with Ajax binding

Question

how can I access grid row count with Ajax binding in Telerik ASP.Net MVC grid? I need to display total in a footer, see code snippet below. The total has to update on insert and delete.

With server binding, there is @Model.Count(). How can I do the same thing with Ajax binding?

thank you!

    @{
    Html.Telerik()
        .Grid<ContractMonth>()
        .Name("contractMonthGrid")
        .DataBinding(dataBinding => dataBinding
            .Ajax()
            .Select("_AjaxBinding", "ContractMonth")
            .Insert("_AjaxInsert", "ContractMonth")
            .Delete("_AjaxDelete", "ContractMonth")
            )
        .DataKeys(keys => keys.Add(c => c.Id))
        .ToolBar(commands => commands.Insert())
        .Columns(columns =>
        {
            columns.Bound(o => o.StartDate).EditorTemplateName("Date").FooterTemplate(@<text>@Model.Count()</text>);

nemesv nemesv · Accepted Answer · 2012-07-01T05:10:05

The Telerik MVC grid supports server and Ajax aggregates:

The following aggregates are supported:

Average

Count

Min

Max

Sum

To specify the aggregates for a column use the Aggregates method

So in your sample:

.Columns(columns =>
    {
        columns.Bound(o => o.StartDate)
               .EditorTemplateName("Date")
               .Aggregate(aggregates => aggregates.Count())
               .FooterTemplate(@<text>@item.Count</text>)
               .ClientFooterTemplate("<#= Count #>");
    }

If you need the row count "outside" the grid you can use the grid's client side API:

<script type="text/javascript">
$(function() {
    var totalRows = $("#contractMonthGrid").data("tGrid").total;
    //do something with totalRows 
});
</script>

Telerik grid: retrieve row count with Ajax binding

1 Answers