Google Chart With ASP.NET Core can't get it to work

public JsonResult PopulationChart()
{
using (SqlConnection con = new SqlConnection("Data Source=.....;Initial Catalog=....;User ID=....;Password=.....;"))
{
//await con.OpenAsync();
con.Open();
SqlTransaction transaction;
transaction = con.BeginTransaction();
using (SqlCommand cmd = new SqlCommand("GenLocationData", con, transaction))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@UN", username);
//cmd.Parameters.AddWithValue("@PW", password);
//await cmd.ExecuteNonQueryAsync();
cmd.ExecuteNonQuery();
transaction.Commit();
var populationList = _smscontext.LocationDatas.OrderBy(xx => xx.Location).ToList();
return Json(populationList);
//return RedirectToAction("Index", "UserHome");
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError("", ex.Message);
var populationList = _smscontext.LocationDatas.OrderBy(xx => xx.Location).ToList();
return Json(populationList);
}
}
}
}

"text/javascript">

//google.charts.load('current', {

// packages: ['corechart']

//});

google.charts.load('current', { packages: ['corechart', 'bar'] });

google.charts.setOnLoadCallback(LoadData);

function LoadData()

{

$.ajax({

url: '@Url.Action("PopulationChart","SMS")',

dataType: "json",

type: "GET",

error: function (xhr, status, error)

{

var err = eval("(" + xhr.responseText + ")");

toastr.error(err.message);

success: function (data)

{

PopulationChart(data);

return false;

}

});

return false;

}

function PopulationChart(data) {

var tdata = new google.visualization.DataTable(data);

tdata.addColumn('string', 'Location');

tdata.addColumn('number', 'Count');

for (var i = 0; i < data.length; i++) {

//tdata.data.addRow([data[i].Location, data[i].Count]);

var xxx = data[i].Location;

tdata.addRow([data[i].Location, 1]);

}

var options = {

'title': 'How Much Pizza I Ate Last Night',

//'width': 500,

//'height': 300

//is3D: true

};

var chart = new google.visualization.BarChart(document.getElementById('chart_div'));

chart.draw(tdata, options);

return false;

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.