PivotGridV2 in Razor Pages

This article describes how to seamlessly integrate and configure the Telerik UI PivotGridV2 for ASP.NET Core in Razor Pages applications.

You can use any of the available data binding approaches to bind the component to data in a Razor Pages application.

Referencing Handler Methods in Razor Pages

Razor Pages is an alternative to the MVC pattern that makes page-focused coding easier and more productive. This approach consists of a cshtml file and a cshtml.cs file (by convention, the two files have the same name).

The cshtml.cs file, known as the PageModel, contains handler methods that respond to HTTP requests. These methods are prefixed with On followed by the HTTP verb (for example, OnGet, OnPost, OnPostRead, OnPostCreate).

Handler methods declared in a PageModel can be referenced from any Razor Page using one of the following URL patterns:

• Using Url.Page()

  C#

  Url.Page("PageName", "HandlerName")
  // OR
  Url.Page("/FolderName/PageName", "HandlerName")

  For example, Url.Page("Index", "Read") references the OnPostRead or OnGetRead handler method in the Index.cshtml.cs file.

• Using a query string

  C#

  Url("/PathToPage?handler=HandlerName")

  For example, Url("/Index?handler=Read") references the OnPostRead or OnGetRead handler method in the Index page.

For more information on Razor Pages architecture and concepts, refer to the official Microsoft documentation.

Binding to Remote Data

The following example demonstrates how to configure the PivotGridV2 DataSource for Ajax data binding to an Online Analytical Processing (OLAP) cube within a Razor Pages application.

1. Add the OLAP service dll (https://demos.telerik.com/service/v2/olap/msmdpump.dll) as a Read request URL in the DataSource configuration to bind the PivotGridV2 to data over an OLAP cube. Since the data is requested from the online accessible OLAP service, it is not required to send the anti-forgery token with the POST request.

2. Define the desired initial rows, columns and measures in the DataSource.

   HtmlHelperTagHelperIndex.cshtml.cs

   Razor

       @page
       @model IndexModel
       @using Kendo.Mvc.UI
   
       @(Html.Kendo().PivotGridV2()
           .Name("pivotgrid")
           .ColumnWidth(200)
           .Height(580)
           .DataSource(dataSource => dataSource
               .Xmla()
               .Columns(columns => {
                   columns.Add("[Date].[Calendar]").Expand(true);
                   columns.Add("[Product].[Category]");
               })
               .Rows(rows => rows.Add("[Geography].[City]").Expand(true))
               .Measures(measures => measures.Values(new string[]{"[Measures].[Reseller Freight Cost]"}))
               .Transport(transport => transport
                   .Connection(connection => connection
                       .Catalog("Adventure Works DW 2008R2")
                       .Cube("Adventure Works"))
                   .Read("https://demos.telerik.com/service/v2/olap/msmdpump.dll")
               )
           )
       )

   Razor

       @page
       @model IndexModel
       @using Kendo.Mvc.UI
   
       <kendo-pivotgridv2 name="pivotgrid" column-width="200" height="580">
           <pivot-datasource type="PivotDataSourceType.Xmla">
               <columns>
                   <pivot-datasource-column name="[Date].[Calendar]" expand="true"></pivot-datasource-column>
                   <pivot-datasource-column name="[Product].[Category]"></pivot-datasource-column>
               </columns>
               <rows>
                   <row name="[Geography].[City]" expand="true"></row>
               </rows>
               <measures values=@(new string[] {"[Measures].[Reseller Freight Cost]"} )></measures>
               <transport read-url="https://demos.telerik.com/service/v2/olap/msmdpump.dll">
                   <connection catalog="Adventure Works DW 2008R2" cube="Adventure Works"></connection>
               </transport>
           </pivot-datasource>
       </kendo-pivotgridv2>

   C#

       public class IndexModel : PageModel
       {
           public void OnGet()
           {
   
           }
       }

See Also

• Using Telerik UI for ASP.NET Core in Razor Pages
• Client-Side API of the PivotGridV2
• Server-Side HtmlHelper API of the PivotGridV2
• Server-Side TagHelper API of the PivotGridV2
• Knowledge Base Section