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.
Syncfusion Feedback

pivot grid with local data binding

Thread ID:

Created:

Updated:

Platform:

Replies:

119859 Aug 7,2015 11:49 AM UTC Sep 3,2015 11:12 AM UTC ASP.NET MVC 7
loading
Tags: PivotGrid
Manolo
Asked On August 7, 2015 11:49 AM UTC

Hi,

I want test the pivot grid, but I don't know how to do data binding.

In a grid, I've  datasource function, but in the pivot grid not.

In examples, you use wcf for binding, but i don't want use it

Thanks

Alagarsamy D [Syncfusion]
Replied On August 8, 2015 07:07 AM UTC

Hi Manolo,

Thank you for using Syncfusion products.

Data could be bound to PivotGrid in the form of JSON string. We have created a same sample in the below online link.

Sample Link:
http://jsplayground.syncfusion.com/elm3ohwe

NOTE: If you require a sample with WebAPI controller please let us know so that we will arrange for the same.

Please let us know if you have any concerns.

Thanks,
Alagarsamy D.

Manolo
Replied On August 10, 2015 07:18 AM UTC

Please, can you create a sample?

Thank you

Narendhran M [Syncfusion]
Replied On August 10, 2015 01:30 PM UTC

Hi Manolo,
We have prepared samples for rendering PivotGrid with both JSON data and WebAPI controller. Please find the samples in the below links.

Sample using WebAPI Controller:
http://www.syncfusion.com/downloads/support/directtrac/141759/ze/PivotGrid_SummaryType1745876630

Sample with custom JSON data binding:
http://www.syncfusion.com/downloads/support/forum/119859/PivotGrid_JSONBinding-764314067.zip

Regards,
Narendhran M.

Manolo
Replied On August 31, 2015 02:14 PM UTC

Hi,

I return to test the PivotGrid.

I need get the data from store procedure , (pass the parameters and exec the sp), and show the data in pivotgrid.

In your examples, I need set the Url, but I don't need this, I want set the datasource.

How can I do it?

Ramesh Govindaraj [Syncfusion]
Replied On September 1, 2015 12:30 PM UTC

Hi Manolo,

In general, database is accessed and processed in service side only. Hence URL need to be assigned which is the only option which indicates the service (WCF or WebAPI) end point for our control. We have created a simple PivotGrid sample where SQL table is queried and assigned to the control as ItemSource. Please find the sample link below.  

Sample Link:   http://www.syncfusion.com/downloads/support/forum/119859/ze/SyncfusionMvcApplication15_(3)-1705608531

Please let us know if you require any further assistance on this.

Thanks,
Ramesh G.

Manolo
Replied On September 2, 2015 03:29 PM UTC

Ok, Thanks

Ramesh Govindaraj [Syncfusion]
Replied On September 3, 2015 11:12 AM UTC

 
Hi Manolo,

Thanks for the update.

Please let us know if you have any query.

Regards,
Ramesh G.

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.

Warning Icon 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.Close Icon

;