RadPersistenceManager xml

[newp]

Hi,

I have a radpivotgrid on my asp.net page.

I need to save and reload state but I need to store the XML in the db and not the id such as

Dim fileId As String = Session("CustomPersistenceSettingsKey").ToString()
RadPersistenceManager1.StorageProviderKey = fileId ''need xml here

 

How can i  do that?

 

Thanks

[Vasil]

Hello,

I am not sure I understand your requirements.
Could you explain further what you are trying to achieve?

You can find an help article about storing the state into the database here:
http://docs.telerik.com/devtools/aspnet-ajax/controls/persistenceframework/functionality/-custom-storage-provider

Regards,
Vasil
Telerik by Progress

[newp]

Thanks. My boss wants to save the state of the pivotgrid . He wants the user to be able to have the option to save the pivotgrid he created but he wants to save the XML in the db and restore the XML not a unique id.

User will have 2 buttons-save state and load state. When user clicks save the state of the grid will be stored in db but the XML of grid and when user clicks load grid then the state is loaded. There will be 2 columns in db-grid report name and xml. Based on report name user selects from dropdown the xml will be loaded.

[Vasil]

Hello Newp,

Isn't the article explain exactly what you need then?
Here is demo that shows how can you save multiple things and choose using a dropdown what to be loaded. It is about the Grid, but the same approach can be used for the PivotGrid as well:
http://demos.telerik.com/aspnet-ajax/controls/examples/integration/persisting-grid-settings/defaultcs.aspx

Regards,
Vasil
Telerik by Progress

[newp]

Thanks for the reply. Yes, I think this is what I need. I tried the example and I don't understand why it saves the xml in a file in the app_data folder and doesn't save anything to the database.

[newp]

Thanks it works. I didn't have handles page init on the page_init event.