I am trying to pass daily json data to (var data) in javascript, when the page loads and pass historical json data to (var data2) in javascript. I am little unsure, how do I go about doing this. Please advice, in how can I get (var data) function in javascript to read daily json data and (var data2) on javascript to read historical json data.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
JavaScriptSerializer jss = new JavaScriptSerializer();
ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript",
string.Format("<script type=\"text/javascript\">google.load('visualization','1.0',{{'packages':['corechart','controls']}});google.setOnLoadCallback(function(){{drawVisualization({0},'{1}','{2}','{3}');}});</script>",
jss.Serialize(GetData()),
"Name Example",
"Name",
"Type Example",
"Type Example",
"Type,"));
}
else
{
JavaScriptSerializer jtt = new JavaScriptSerializer();
ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript",
string.Format("<script type=\"text/javascript\">google.load('visualization','1.0',{{'packages':['corechart','controls']}});google.setOnLoadCallback(function(){{drawVisualization({0},'{1}','{2}','{3}');}});</script>",
jtt.Serialize(GetData2()),
"Name Example",
"Name",
"Type Example",
"Type Example",
"Type,"));
}
}
function drawVisualization(dataValues, chartTitle, columnNames, categoryCaption) {
if (dataValues.length < 1)
return;
var data = new google.visualization.DataTable();
data.addColumn('string', columnNames.split(',')[0], 'name');
data.addColumn('number', columnNames.split(',')[1], 'price');
data.addColumn('string', columnNames.split(',')[2], 'type');
data.addColumn('datetime', columnNames.split(',')[3], 'date');
for (var i = 0; i < dataValues.length; i++) {
var date = new Date(parseInt(dataValues[i].Date.substr(6), 10));
data.addRow([dataValues[i].ColumnName, dataValues[i].Value, dataValues[i].Type, date]);
}
var data2 = new google.visualization.DataTable();
data2.addColumn('string', columnNames.split(',')[0], 'name');
data2.addColumn('number', columnNames.split(',')[1], 'price');
data2.addColumn('string', columnNames.split(',')[2], 'type');
data2.addColumn('datetime', columnNames.split(',')[3], 'date');
for (var i = 0; i < dataValues.length; i++) {
var date = new Date(parseInt(dataValues[i].Date.substr(6), 10));
data2.addRow([dataValues[i].ColumnName, dataValues[i].Value, dataValues[i].Type, date]);
}
Many thanks for your help and time.