How can I save the pivot layout to SQL instead of a file?

  • 1p
    delmontyb1p 2 years, 11 months ago

    I’m trying to figure out the best way to go about saving the layout of the pivot view to my SQL database, but so far the only way to go about this is complex.

    I save the layout using the

    this.PivotView1.Write(fileInfo, PersistSettings.Layout);

    However, that has me first creating a file, and using this command to populate the file info. Then taking that file info, and converting it to a byte[] and saving that byte[] into SQL.

    To get it back out, I have to take the byte[] in sql, create a file, then read the file. My goal is to do this all in memory, without having to save/create a file.

    Is this even possible?

    It’s been a long day, and I hope I’m just not connecting the dots. Thanks for any tips.

  • 50p
    Ashish Jindal50p 2 years, 11 months ago


    Unfortunately, there is no direct way to save the layout directly to the database. PivotView can save the layout to a file and then, you need to save it manually in the database as you mentioned.


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.




/developer, royalty-free

Add maintenance for $300. This renewable one-year plan entitles you to all major releases made available during its term and to unlimited phone support.

Contact Sales