ASPxGridView数据汇总

    数据汇总一般都是列汇总，也有需要横向的，ASPxGridView在这方面提供了支持实现起来很简单。这里只是把数据库改成常用的Northwind以便调试。

1.列汇总

    只需要设置TotalSummary属性就能实现一般的汇总，后台不需要代码。下面是前台代码

         < dxwgv:ASPxGridView ID = " ASPxGridView1 "  runat = " server "   AutoGenerateColumns = " False "  DataSourceID = " SqlDataSource1 "  KeyFieldName = " OrderID "   >
             < TotalSummary >
                 < dxwgv:ASPxSummaryItem FieldName = " Subtotal "  SummaryType = " Sum "    />
                 < dxwgv:ASPxSummaryItem FieldName = " OrderID "    SummaryType = " Count "   />
                 < dxwgv:ASPxSummaryItem FieldName = " ShippedDate "  SummaryType = " Max "   />
             </ TotalSummary >
             < Settings ShowFooter = " True "   />
             < Styles >
                 < Footer BackColor = " #6699FF " >
                 </ Footer >