c# - Google Charts json data not loading -

-

i'm using asp.net mvc , google charts try , generate simple line graph 2 data records. i'm pulling data database, data isn't appearing on chart. data consists of 2 records 2 fields: weekofentry(datetime) , weight (decimal). chart appears, data points aren't there. i'm guessing data formatted improperly?

here's javascript:

<script type="text/javascript">      //load visualization api library , linechart library.     google.load('visualization', '1.0', { 'packages': ['corechart'] });      //set callback run when google visualization api loaded.     google.setonloadcallback(drawloseatonlinechart);      //callback creates , populates data table, instantiates line chart,     //passes in data, , draws it.     function drawloseatonlinechart() {          var url = "@url.action("getchartstatistics")";          var jsondata = $.ajax({             method: 'get',             url: url,             datatype: 'json',             async: false         }).responsetext;          var data = new google.visualization.datatable();         data.addcolumn('string', 'weekofentry');         data.addcolumn('number', 'weight');          (var = 0; < data.length; i++) {             data.addrow([jsondata[i].weekofentry, jsondata[i].weight]);         }          var options = {             title: 'weight progression',             legend: {                 position: 'right',                 alignment: 'center'             },             vaxis: {                 title: 'weight'             },             haxis: {                 title: 'week',                 slantedtext: true,                 slantedtextangle: 45              },             colors: ['e81a00']         };          var chart = new google.visualization.linechart(document.getelementbyid('lose-a-ton-line-chart'));          chart.draw(data, options);     } </script>

here's part of getchartstatistics() method:

var linechartdata = (from in db.associates             join aw in db.associateweights                 on a.registrationid equals aw.registrationid             a.eventid == eventid &&                   a.username == currentuser             select new linechartdata             {                 weight = aw.weight,                 weekofentry = aw.weekofentry             });  return json(linechartdata, jsonrequestbehavior.allowget);

edit: here's how json data formatted when gets returned:

"[{"weight":190.0,"weekofentry":"\/date(1431921600000)\/"},{"weight":121.0,"weekofentry":"\/date(1432526400000)\/"}]"

any ideas on why data isn't loading?

you had issue in loop. here modified code.

//load visualization api library , linechart library.     google.load('visualization', '1.0', { 'packages': ['corechart'] });      //set callback run when google visualization api loaded.     google.setonloadcallback(drawloseatonlinechart);  var url = "@url.action("getchartstatistics")";  var result = $.ajax({     method: 'get',     url: url,     datatype: 'json',     async: false }); var jsondata = result.responsetext; var data = new google.visualization.datatable(); data.addcolumn('string', 'weekofentry'); data.addcolumn('number', 'weight');  $.each(json.parse(jsondata), function (index, obj) {     data.addrow([obj.weekofentry, obj.weight]); });  var options = {     title: 'weight progression',     legend: {         position: 'right',         alignment: 'center'     },     vaxis: {         title: 'weight'     },     haxis: {         title: 'week',         slantedtext: true,         slantedtextangle: 45      },     colors: ['e81a00'] };  var chart = new google.visualization.linechart(document.getelementbyid('chart_div'));  chart.draw(data, options);   public jsonresult getchartstatistics()     {         var linechartdata = new list<linechartdata>() {              new linechartdata() { weekofentry = "sat", weight = 1},             new linechartdata() { weekofentry = "sat1", weight = 2},             new linechartdata() { weekofentry = "sat2", weight = 3},             new linechartdata() { weekofentry = "sat3", weight = 4},         };          return json(linechartdata, jsonrequestbehavior.allowget);     }

Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more