This:
var jsonData = $.ajax({
url: "teste.cshtml",
dataType:"json",
async: false
}).responseText;
produces a string, not a javascript object. You need to parse the JSON
into an object before you can use it with the function Sergey wrote:
var data = jsonToTable(JSON.parse(jsonData), ['ESTADO', 'CNT']);
On Tuesday, August 19, 2014 11:09:09 AM UTC-4, Tiago Correia wrote:
>
> // Load the Visualization API and the piechart package.
> google.load('visualization', '1', {'packages':['corechart']});
>
> // Set a callback to run when the Google Visualization API is loaded.
> google.setOnLoadCallback(drawChart);
>
> function drawChart() {
> var jsonData = $.ajax({
> url: "teste.cshtml",
> dataType:"json",
> async: false
> }).responseText;
>
>
> function jsonToTable(json, order) {
> var headers = [];
> var data = [headers];
> for (var i = 0; i < json.length; i++) {
> var row = [];
> for (var j = 0; j < order.length; j++) {
> if (headers.length <= j) {
> headers.push(order[j]);
> }
> row.push(json[i][order[j]]);
> }
> data.push(row);
> }
> return google.visualization.arrayToDataTable(data);
> }
>
> var data = jsonToTable(jsonData, ['ESTADO', 'CNT']);
>
> // Instantiate and draw our chart, passing in some options.
> var chart = new
> google.visualization.LineChart(document.getElementById('chart_div'));
> chart.draw(data, {width: 800, height: 600});
> }
>
>
> I've put like you said and it gives me the following error:
>
> Data column(s) for axis #0 cannot be of type string×
>
>
>
> Terça-feira, 19 de Agosto de 2014 13:38:46 UTC+1, Tiago Correia escreveu:
>
> I'm using webmatrix to create a chart from my db. I have one cshtml file
>
> var db = Database.Open("MyDB");
> var data = @"SELECT ESTADO, COUNT(*) CNT FROM graficos WHERE ESTADO IS
> NOT NULL GROUP BY ESTADO";
> var resultadoSql = db.Query(data);
> Json.Write(resultadoSql, Response.Output);
> Response.ContentType = "application/json";
>
> That is producing this result
>
> [{"ESTADO":"ABERTO","CNT":63},{"ESTADO":"ASSOCIADO A AVARIA
> PAI","CNT":9},{"ESTADO":"AVARIA PAI COM EM
> EXECUÇÃO","CNT":3},{"ESTADO":"AVARIA PAI EM
> DESPISTE","CNT":3},{"ESTADO":"CANCELADO","CNT":3},{"ESTADO":"EM
> DESPISTE","CNT":18},{"ESTADO":"EM
> EXECUÇÃO","CNT":27},{"ESTADO":"FECHADO","CNT":189},{"ESTADO":"RESOLVIDO","CNT":51}]
>
> And on the page that the chart will be displayed (yeap google charts :x)
>
> // Load the Visualization API and the piechart package.
> google.load('visualization', '1', {'packages':['corechart']});
>
> // Set a callback to run when the Google Visualization API is loaded.
> google.setOnLoadCallback(drawChart);
>
> function drawChart() {
> var jsonData = $.ajax({
> url: "teste.cshtml",
> dataType:"json",
> async: false
> }).responseText;
>
> // Create our data table out of JSON data loaded from server.
> var data = new google.visualization.DataTable(jsonData);
>
> // Instantiate and draw our chart, passing in some options.
> var<span style="outline:0px;color:rgb(0,0,0)
>
> ...
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
