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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Efficient way to save & apply chart metadata?

Thread ID:

Created:

Updated:

Platform:

Replies:

121044 Nov 5,2015 02:42 PM UTC Nov 6,2015 12:05 PM UTC ASP.NET Web Forms 1
loading
Tags: Chart
Adham
Asked On November 5, 2015 02:42 PM UTC

Hello 

I have an application where a user can build up a chart and set various chart options, e.g. legend position, gridlines, axis intervals, trendlines, chart type etc. Once configured as desired I plan to save the metadata (to a database). The idea being when the user wants to load the chart again I will apply the saved metadata so that the chart appears as the user previously configured it.

My question is whether there is "built-in" way of achieving this with the control. At the moment I am planning to save all the settings into a specially designed database table to accommodate all the settings or build up some XML and save it and parse it out again when applying the properties of the chart control.

Could you advise on what would be the "best approach" (if indeed there is one)?

Thanks in advance.

Best regards
Adham

Deepaa Pragaasam [Syncfusion]
Replied On November 6, 2015 12:05 PM UTC

Hi Adham,

Thanks for contacting syncfusion support.

We have analyised your query.

We donot have any inbuilt method for saving and loading the chart from the database.
We have performed the required operation using AJAX PageMethods. PageMethods is a new mechanism in ASP.NET applications where the server code can be bound to ASP.NET pages. It is an easy way to communicate asynchronously with the server using ASP.NET AJAX technologies. It is an alternate to calling the page that is reliable and carries a low risk. It is basically used to expose the web methods to the client script. 

Set EnablePageMethods=”true” in ScriptManger tag that allows to call a web page method directly from JavaScript.

Code Example:

[ASPX]

<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true"></asp:ScriptManager>

The below code example illustrates how to save the chart to the database

Code example:

[JS]

function save() {

var chart = null;

var chart = $("#Chart1").ejChart("instance");

var saving = chart.model;

var stringify = String(JSON.stringify(saving));

PageMethods.save(stringify);

}
The following WebMethod is executed when the AJAX PageMethods call is made from client side. This method accepts the JSON string from client side and it is inserted in the database.

[ASPX.cs]

[WebMethod]

public static void save(string param1)

{

NorthWindDataContextDiagramEntities entities = new NorthWindDataContextDiagramEntities();

SaveDatabase gh = new SaveDatabase();

gh.Diagram2 =param1;

gh.Diagram3 = "dw";

entities.SaveDatabases.Add(gh);

entities.SaveChanges();

}

The below code illustrates how to load chart from the database

[JS]

function load() {

PageMethods.load(OnSuccess);

}

function OnSuccess(stringify) {

stringify = JSON.parse(stringify);

$("#Chart2").ejChart(stringify);

}
The following HttpPost is executed when the AJAX PageMethods call is made from client side. This method retrieves the JSON string from the database and send to client side.

ASPX.CS




[WebMethod]

String name, jsonstring;

public static string load()

{

NorthWindDataContextDiagramEntities entities = new NorthWindDataContextDiagramEntities();

entities = SqlCE;

List<SaveDatabase> loadJSON = entities.SaveDatabases.ToList<SaveDatabase>();

foreach (SaveDatabase data in loadJSON)

{

jsonstring = data.JSONString;

name = data.Name;

}

string loadcontent = jsonstring;

return loadcontent;

}

Screenshot :

 

Two Separate charts are loaded

 

Now the series type is changed to spline and the marker is enabled and the chart is saved .

 

On clicking the load button the chart from the loaded database also is changed to spline

 



We have attched the sample for your reference

SampleLink:Chart_saving_and_loading_from_database

Please let us know if you have any concerns

Regards,

Deepaa.


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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

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

;