We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

About Pivot Client data source

Thread ID:

Created:

Updated:

Platform:

Replies:

129623 Mar 25,2017 08:54 PM Mar 27,2017 09:01 AM ASP.NET Web Forms 1
loading
Tags: PivotClient
Jarobec
Asked On March 25, 2017 08:54 PM

How can i change or bind pivot client data source from database? 
My example coding like that

aspx file code:
<ej:PivotClient ID="PivotClient1" runat="server" OnLoad="PivotClient1_Load" OnDataBinding="PivotClient1_DataBinding" ClientIDMode="Static" Title="Test1">
     <ToolbarIconSettings EnableChartTypes="true" />
     <DisplaySettings Mode="ChartAndGrid" EnableTogglePanel="true" DefaultView="Grid" />
     <DataSource EnableAdvancedFilter="true" IsFormattedValues="true"></DataSource>
</ej:PivotClient>

aspx.cs file code:
protected void PivotClient1_DataBinding(object sender, EventArgs e)
{
     try
     {
          PivotDataSource pds = new PivotDataSource();

          string a = JsonData(GetReportData("1").Tables["Rpt1"]);
          pds.Data = a;

          PivotClient1.Model.DataSource = pds;              
     }
     catch
     {

     }
}

Manikandan Murugesan [Syncfusion]
Replied On March 27, 2017 09:01 AM

Hi Jarobec, 

Thank you for using Syncfusion products. 

We have prepared simple PivotClient sample using local database for your reference. Please find the sample in the following link. 
  
Please let us know if you have any concerns. 

Regards, 
Manikandan M. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;