How to bind the Controller data to Kendo chart
My razor code looks like
@(Html.Kendo().Chart<MvcKendoDemo.Models.tblGraph>()
.Name("DBPlot")
.Title(title => title
.Text("Kendo Plot DB Data")
.Position(ChartTitlePosition.Bottom)
)
.DataSource(ds => ds.Read(read => read.Action("GetGraphData", "Graph")))
.Series(series =>
{
series.Column(model => model.STATS).Name("Stats");
})
.CategoryAxis(axis => axis
.Categories(model => model.DAY)
.MajorGridLines(lines => lines.Visible(false))
)
.Tooltip(tooltip => tooltip
.Visible(true)
.Format("{0}%")
.Template("#= series.name #: #= value #")
)
)
And Controller code
public ActionResult GetGraphData()
{
var stats=new List<int?>();
var day=new List<string>();
foreach (var item in DB.tblGraphs)
{
stats.Add(item.STATS);
day.Add(item.DAY);
}
return Json(new {stats=stats,day=day });//getting data from EF
}
Result :- Empty graph is displayed with title.
How do i bind the data from controller to Chart.
Thanks in Advance.
My razor code looks like
@(Html.Kendo().Chart<MvcKendoDemo.Models.tblGraph>()
.Name("DBPlot")
.Title(title => title
.Text("Kendo Plot DB Data")
.Position(ChartTitlePosition.Bottom)
)
.DataSource(ds => ds.Read(read => read.Action("GetGraphData", "Graph")))
.Series(series =>
{
series.Column(model => model.STATS).Name("Stats");
})
.CategoryAxis(axis => axis
.Categories(model => model.DAY)
.MajorGridLines(lines => lines.Visible(false))
)
.Tooltip(tooltip => tooltip
.Visible(true)
.Format("{0}%")
.Template("#= series.name #: #= value #")
)
)
And Controller code
public ActionResult GetGraphData()
{
var stats=new List<int?>();
var day=new List<string>();
foreach (var item in DB.tblGraphs)
{
stats.Add(item.STATS);
day.Add(item.DAY);
}
return Json(new {stats=stats,day=day });//getting data from EF
}
Result :- Empty graph is displayed with title.
How do i bind the data from controller to Chart.
Thanks in Advance.