<%@ Page Language="C#" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
<title>Telerik ASP.NET Example</title>
</head>
<body>
<form id="form1" runat="server">
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
<telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadPivotGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadPivotGrid1"></telerik:AjaxUpdatedControl>
</UpdatedControls>
</telerik:AjaxSetting>
<telerik:AjaxSetting AjaxControlID="RadPivotGrid2">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadPivotGrid2"></telerik:AjaxUpdatedControl>
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
</telerik:RadAjaxLoadingPanel>
<div class="demo-container no-bg">
<h2 class="qsfSubtitle">SQLDataSource
</h2>
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Height="370px"
AllowPaging="true" AllowFiltering="false" ShowFilterHeaderZone="false">
<ClientSettings Scrolling-AllowVerticalScroll="true">
</ClientSettings>
<DataCellStyle Width="100px" />
<Fields>
<telerik:PivotGridColumnField DataField="ShipCountry">
</telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="Year">
</telerik:PivotGridColumnField>
<telerik:PivotGridRowField DataField="CategoryName">
</telerik:PivotGridRowField>
<telerik:PivotGridRowField DataField="ProductName">
</telerik:PivotGridRowField>
<telerik:PivotGridAggregateField DataField="Quantity" Aggregate="Sum">
</telerik:PivotGridAggregateField>
</Fields>
</telerik:RadPivotGrid>
<br />
<h2 class="qsfSubtitle">ObjectDataSource
</h2>
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid2" runat="server" DataSourceID="ObjectDataSource1" Height="370px"
AllowPaging="true" AllowFiltering="false" ShowFilterHeaderZone="false">
<ClientSettings Scrolling-AllowVerticalScroll="true">
</ClientSettings>
<DataCellStyle Width="100px" />
<Fields>
<telerik:PivotGridRowField ZoneIndex="0" DataField="PlaneType" Caption="PlaneType">
</telerik:PivotGridRowField>
<telerik:PivotGridRowField ZoneIndex="1" DataField="PlaneModel" Caption="PlaneModel">
</telerik:PivotGridRowField>
<telerik:PivotGridAggregateField ZoneIndex="0" DataField="Passengers" Caption="Passengers"
UniqueName="Passengers" Aggregate="Sum">
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField ZoneIndex="1" DataField="Cargo" Caption="Cargo"
UniqueName="Cargo" Aggregate="Sum">
</telerik:PivotGridAggregateField>
<telerik:PivotGridColumnField ZoneIndex="0" DataField="Country" Caption="Country"
UniqueName="Country">
</telerik:PivotGridColumnField>
<telerik:PivotGridColumnField ZoneIndex="1" DataField="City" Caption="City" UniqueName="City">
</telerik:PivotGridColumnField>
</Fields>
</telerik:RadPivotGrid>
<br />
<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [ProductID], [ProductName], [ShipCountry], [CategoryName], [Year], [Quantity] FROM [Product Reports Comparison]"
runat="server"></asp:SqlDataSource>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetPivotData"
TypeName="Telerik.Web.Examples.PivotItemData"></asp:ObjectDataSource>
</div>
</form>
</body>
</html>