THEMES

Grid - Data Summaries Grid Totals

Company NameCityRegionCountryUnit PriceQuantity
Count : 2155    24
Page size:
select
 2155 items in 216 pages
Island TradingCowesIsle of WightUK1910
Island TradingCowesIsle of WightUK4020
Island TradingCowesIsle of WightUK610
Island TradingCowesIsle of WightUK3421
Reggiani CaseificiReggio Emilia Italy12.516
Reggiani CaseificiReggio Emilia Italy34.840
Reggiani CaseificiReggio Emilia Italy1320
Ricardo AdocicadosRio de JaneiroRJBrazil1912
Ricardo AdocicadosRio de JaneiroRJBrazil1235
QUICK-StopCunewalde Germany2250
The KaxGrid is a powerful data shaping control that includes a variety of data summary calculation options. Total Summaries are aggregate function values calculated against all rows within the KaxGrid, and displayed within the Footer. Built-in aggregate functions include: Min, Max, Avg, Sum and Count.
The Footer is displayed if the ShowFooter property is set to true.

Kettic asp.net ajax grid control support many features, such as: binding large data to grid in asp.net, adding filter control to grid in asp.net and scrolling grid column and row in asp.net.

<%@ Page Title="" Language="C#" MasterPageFile="~/Demo.Master" AutoEventWireup="true" CodeBehind="GridTotals.aspx.cs" Inherits="Kettic.AspNet.Demo.KaxGridDemo.DataSummaries.GridTotals" %>

<%@ Register TagPrefix="kettic" Namespace="Kettic.AspNet.Controls" Assembly="Kettic.AspNet.Controls,Version=2014.04.1129.0" %>
<asp:Content ID="Content1" ContentPlaceHolderID="DemoContent" runat="server">
    <kettic:KaxGrid ID="grid" runat="server" DataSourceID="AccessDataSource1" Width="100%"
        AutoGenerateColumns="False" AllowSorting="True" AllowPaging="True" GridLines="None"
        ShowFooter="True">
        <ClientSettings>
            <Selecting AllowRowSelect="True" />
        </ClientSettings>
        <MainView>
            <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
            <Columns>
                <kettic:GridBoundColumn HeaderText="Company Name" DataField="CompanyName" UniqueName="CompanyName" Aggregate="Count" />
                <kettic:GridBoundColumn HeaderText="City" DataField="City" UniqueName="City" />
                <kettic:GridBoundColumn HeaderText="Region" DataField="Region" UniqueName="Region" />
                <kettic:GridBoundColumn HeaderText="Country" DataField="Country" UniqueName="Country" />
                <kettic:GridNumericColumn HeaderText="Unit Price" DataField="UnitPrice" UniqueName="UnitPrice" />
                <kettic:GridNumericColumn HeaderText="Quantity" DataField="Quantity" UniqueName="Quantity" Aggregate="Avg" DataFormatString="{0:F0}"/>
            </Columns>
        </MainView>
    </kettic:KaxGrid>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/nwind.mdb"
SelectCommand="SELECT [Customers.CompanyName] AS CompanyName, [City], [Region], [Country],
[Salesperson], [OrderID], [OrderDate], [ProductID], [ProductName], [UnitPrice], [Quantity], [Discount], [ExtendedPrice], [Freight] FROM [Invoices]"></asp:AccessDataSource>

</asp:Content>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Kettic.AspNet.Demo.KaxGridDemo.DataSummaries
{
    public partial class GridTotals : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}
Version:2014.04.1129
Copyright © 2008-2017 Kettic Inc
Your Next ASP.NET Site Best Choice

Get started today and download ASP.NET AJAX UI Controls and SDKs for 30-day free try.

Kettic provide rich online demos to view the features of each UI control. And you can find comprehensive guide to use ASP.NET controls

For more information about Kettic UI SDK, please visit the ASP.NET AJAX Controls webpage. For immediate assistance, contact us by Email at support@kettic.com.