|
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Sample2.aspx.cs" Inherits="TestGroupingView.Sample10" MasterPageFile="~/Site.Master" %>
<%@ Register Assembly="GroupingView" Namespace="UNLV.IAP.WebControls" TagPrefix="cc1" %>
<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="Title">
Sample 2: Using the ItemTemplate to list items within a group
</asp:Content>
<asp:Content runat="server" ContentPlaceHolderID="ContentPlaceHolder1">
<cc1:GroupingView ID="GroupingView1" runat="server"
GroupingDataField="Region"
DataSourceID="sql1"
AutobindDataSourceChildren="true"
>
<GroupTemplate>
<asp:Label ID="lblRegion" runat="server"
Text='<%# Eval("Region") %>'
Font-Bold="true"
Font-Size="Large"
ForeColor="ForestGreen"
Font-Names="Tahoma,Verdana,Arial,Sans-Serif"
/>
<table>
<%-- group header --%>
<tr>
<th width="100" align="left">City</th>
<th width="100" align="left">State</th>
<th width="100" align="right">Sales</th>
</tr>
<%-- group data items --%>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
<%-- group footer --%>
<tr><td colspan="3"><hr /></td></tr>
<tr>
<td align="right" colspan="2">Group total:</td>
<td align="right">
<cc1:Aggregation runat="server" Function="Sum"
DataField="Sales"
FormatString="{0:#,##0.00}"
/>
</td>
</tr>
<tr>
<td align="right" colspan="2">Group average:</td>
<td align="right">
<cc1:Aggregation runat="server" Function="Avg"
DataField="Sales"
FormatString="{0:#,##0.00}"
/>
</td>
</tr>
</table>
<br /><br />
</GroupTemplate>
<ItemTemplate>
<%-- define items within a group --%>
<tr>
<td><%#Eval("City") %></td>
<td><%#Eval("State") %></td>
<td align="right"><%#Eval("Sales", "{0:#,##0.00}") %></td>
</tr>
</ItemTemplate>
</cc1:GroupingView>
Grand Total:
<cc1:Aggregation runat="server" Function="Sum"
DataSourceID="sql1"
DataField="Sales"
FormatString="{0:#,##0.00}"
/>
<br />
Average per city:
<cc1:Aggregation ID="Aggregation1" runat="server" Function="Avg"
DataSourceID="sql1"
DataField="Sales"
FormatString="{0:#,##0.00}"
/>
<asp:SqlDataSource ID="sql1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Cities] Order By Region, State, City">
</asp:SqlDataSource>
</asp:Content>
<asp:Content runat="server" ContentPlaceHolderID="Description">
This example demonstrates the use of the <code>ItemTemplate</code> to
define the display for individual items within a group. A placeholder control
with an ID set to <code>itemPlaceholder</code> is positioned in the
<code>GroupTemplate</code>. <code>Aggregation</code> controls appear in the
<code>GroupTemplate</code> for subtotals, and below the <code>GroupingView</code>
for grand totals.
</asp:Content>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
With a background in education, music, application development, institutional research, data governance, and business intelligence, I work for the University of Nevada, Las Vegas helping to derive useful information from institutional data. It's an old picture, but one of my favorites.