PivotGrid WebForms Data Binding From Database

Question

HiI need to know how I can use pivot grid with data Binding from Database for a WebForms ApplicationThanks

Manikandan Murugesan · Answer

Hi Olman,

You can bind data from database using AJAX method in “load” event. Please refer below code snippet.

Code Snippet: [aspx]

<ej:PivotGrid ID="PivotGrid1" runat="server" ClientIDMode="Static" EnableGroupingBar="true" PivotTableFieldListID="PivotSchemaDesigner">

</ej:PivotGrid>

Code Snippet: [javascript]

function onLoad(args) {

args.model.dataSource.data = pivot_dataset;

//Here you can get data from database using AJAX method.

}

Meanwhile, we have prepared prototype sample. Please find the sample in below link.

Thanks,

Manikandan.