Pivot tables
-
I m using a Pivot table and a chart in my asp.net 2.0(C#) application. I want to edit data in Pivot table and save in the sql database. Is there any way of doing it?
What data do you want to save? Surely the data displayed in a pivot table is aggregated... If you change the underlying data, I'm sure you can save it, but the answer to your question depends very much on how you are supplying the data to your pivot table - it's really just a matter of creating an update sql statement for anything that changes...
-
What data do you want to save? Surely the data displayed in a pivot table is aggregated... If you change the underlying data, I'm sure you can save it, but the answer to your question depends very much on how you are supplying the data to your pivot table - it's really just a matter of creating an update sql statement for anything that changes...
I saw one example of how to display Pivot Table protected PivotTableClass pt; pt = new PivotTableClass(); pt.ConnectionString ="Provider=SQLOLEDB.1;Data Source=AHD-2003;database=northwind;user id=sa;password=;"; pt.DataMember ="select * from suppliers"; pt.ShowDetails(); I m using OWC10. But there is no method named ShowDetails(). How can it be? Do u have any example of how to display Pivot table programmatically.