This feature is not supported yet in WebGrid. However using column footer and custom aggegrate function, you could show the total row of the table in the column footer. We have already provide an article titled "Walkthrough: Using Custom Aggregate function in WebGrid" in the WebGrid docs. In order to retrieve the total row in the table you will need to re-query the data since the WebGrid does not supply this information.

Do you think this will be supported soon?  I would hate re-query the data to get the total number of rows regardless if I'm paging or not.  This is something our users use quite frequently.

I have just been informed by the developer that this feature has already been supported. You will need to set ColumnFooterAggegrateMode to CalculateAllData to calculate all the row using aggegrate count function.

Here is the snippet:

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="316px" UseDefaultStyle="True"
    Width="644px" DefaultStyleMode="Elegant" OnInitializeDataSource="WebGrid1_InitializeDataSource" DataSourceID="AccessDataSource1">
    <LayoutSettings AllowEdit="Yes" PagingMode="ClassicPaging" PagingStyleUI="Slider" PagingSliderWidth="120" 
        AllowColumnFreezing="Yes" AllowColumnMove="Yes" AllowFilter="Yes" AllowGrouping="Yes" AllowSorting="Yes" 
        PagingDetectPartialGroupRows="True" ColumnFooters="Yes" ColumnFooterAggregateMode="CalculateAllData">
        <FreezePaneSettings ActiveFrozenColumns="2" />
    </LayoutSettings>
    <RootTable DataKeyField="OrderID">
        <Columns>
            <ISWebGrid:WebGridColumn Caption="OrderID" DataMember="OrderID" DataType="System.Int32"
                Name="OrderID" Width="100px" AggregateFunction="Count" FooterText="Total: ">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="CustomerID" DataMember="CustomerID" Name="CustomerID"
                Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="EmployeeID" DataMember="EmployeeID" DataType="System.Int32"
                Name="EmployeeID" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="OrderDate" DataMember="OrderDate" DataType="System.DateTime"
                Name="OrderDate" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="RequiredDate" DataMember="RequiredDate" DataType="System.DateTime"
                Name="RequiredDate" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShippedDate" DataMember="ShippedDate" DataType="System.DateTime"
                Name="ShippedDate" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipVia" DataMember="ShipVia" DataType="System.Int32"
                Name="ShipVia" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="Freight" DataMember="Freight" DataType="System.Decimal"
                Name="Freight" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipName" DataMember="ShipName" Name="ShipName"
                Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipAddress" DataMember="ShipAddress" Name="ShipAddress"
                Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipCity" DataMember="ShipCity" Name="ShipCity"
                Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipRegion" DataMember="ShipRegion" Name="ShipRegion"
                Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipPostalCode" DataMember="ShipPostalCode" Name="ShipPostalCode"
                Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="ShipCountry" DataMember="ShipCountry" Name="ShipCountry"
                Width="100px">
            </ISWebGrid:WebGridColumn>
        </Columns>
    </RootTable>
</ISWebGrid:WebGrid>