Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
Google Chart - DataTable.addRow()
Learn Avid
Jun 19 2017 1:11 PM
729
Reply
Hello,
I`m trying add rows to a DataTable() but my column headers have spacing and special symbols like Meat/Poultry, Dairy Products, etc.,
$.ajax({
url:
"@Url.Action("
TotalSales
", "
Chart
")"
,
data:
"{}"
,
dataType:
"json"
,
type:
"POST"
,
contentType:
"application/json"
,
success:
function
(data) {
var
Data =
new
google.visualization.DataTable();
Data.addColumn(
'number'
,
'Confections'
);
Data.addColumn(
'number'
,
'Meat/Poultry'
);
Data.addColumn(
'number'
,
'Condiments'
);
Data.addColumn(
'number'
,
'Dairy Products'
);
Data.addColumn(
'number'
,
'Beverages'
);
Data.addColumn(
'number'
,
'Grains/Cereals'
);
Data.addColumn(
'number'
,
'Seafood'
);
Data.addColumn(
'number'
,
'Produce'
);
Data.addColumn(
'number'
,
'ShippingYear'
);
for
(
var
i = 0; i < data.length; i++) {
console.log(
"Im in ComboChart Success"
);
Data.addRow([data[i].ShippingYear, data[i].Confections,
data[i].Meat/ Poultry, data[i].Condiments, data[i].Dairy Products, data[i].Beverages,
data[i].Grains/ Cereals, data[i].Seafood, data[i].Produce]);
console.log(
"Inserting data"
);
}
var
options = {
height: 600,
width: 700,
title:
'Total Category Wise Sales 1996_1997'
,
vAxis: {
title:
'Sales'
,
format:
'currency'
},
hAxis: {
title:
'ShippingYear'
}
};
var
chartspace =
new
google.visualization.BarChart(document.getElementById(
'comboChart'
));
chartspace.draw(Data, options);
},
error:
function
() {
alert(
"Error loading data! Please try again."
);
}
});
In the above ajax call, Line # 21, 22 cause error.
I can`t add column names which are different. Please help me to achieve this.
Thanks in advance.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
Background Color in MVC
how to create login page in jquery and in asp.net