New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

EntityDataSource

EntityDataSource

empty
QuantityShipCountryYear
CategoryNameProductName
empty
GermanyGermany Total USAUSA TotalGrand Total
199619971998199619971998
empty
BeveragesChartreuse verte
Côte de Blaye
Guaraná Fantástica
Ipoh Coffee
Lakkalikööri
Laughing Lumberjack Lager
Outback Lager
Rhönbräu Klosterbier
Sasquatch Ale
Steeleye Stout
Grand Total
empty
58468018430  30214
  180180202565110290
 6350113 185977190
7240 11230  30142
4253134229 13050180409
525 30 10 1040
 642084 30636120
2265491366187120313449
 20 20 6270132152
 6043103703935144247
980421321627355134842402804839215747
Page size:

RadPivotGrid can be bound to all ASP 3.5 DataSource control types like:

  • EntityDataSource

All you need to do is set the DataSourceID property of the pivot grid to the ID of the datasource control and you are ready to use the provided data.

  • DefaultVB.aspx
<%@ Page Language="VB"  %>

<%@ Register Assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    Namespace="System.Web.UI.WebControls" TagPrefix="asp" %>
<%@ 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">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="RadPivotGrid1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadPivotGrid1" LoadingPanelID="RadAjaxLoadingPanel1"></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">EntityDataSource
            </h2>
            <telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="EntityDataSource1" 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 />
            <asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=NorthwindReadOnlyEntities"
                DefaultContainerName="NorthwindReadOnlyEntities" EntitySetName="Product_Reports_Comparisons">
            </asp:EntityDataSource>
        </div>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance