Hi,
I have created sample using entity framework. Refer the below code.
SQL
CREATE TABLE [dbo].[tblMVCCharts](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Year] [int] NULL,
[Value] [float] NULL
) ON [PRIMARY]
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2008,50)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2009,70)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2010,80)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2011,90)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2012,120)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2013,150)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2014,100)
INSERT INTO [tblMVCCharts] (Year, Value) VALUES (2015,300)
NameSpaces
using System.Web.Helpers;
using System.Web.Mvc;
using System.Collections;
using System.Collections.Generic;
Controller
static practiceEntities pe = new practiceEntities();
ArrayList xValue = new ArrayList();
ArrayList yValue = new ArrayList();
//
// GET: /Home/
public ActionResult Index()
{
return View();
}
public ActionResult ColumnChart()
{
var results = from c in pe.tblMVCCharts
select c;
results.ToList().ForEach(x => xValue.Add(x.Year));
results.ToList().ForEach(y => yValue.Add(y.Value));
new Chart(width: 600, height: 400)
.AddTitle("Chart for Growth")
.AddSeries(chartType: "column", xValue: xValue, yValues: yValue)
.Write("bmp");
return null;
}
public ActionResult BarChart()
{
var results = from c in pe.tblMVCCharts
select c;
results.ToList().ForEach(x => xValue.Add(x.Year));
results.ToList().ForEach(y => yValue.Add(y.Value));
new Chart(width: 600, height: 400)
.AddTitle("Chart for Growth")
.AddSeries(chartType: "bar",xValue: xValue,yValues: yValue)
.Write("bmp");
return null;
}
View
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Column Chart</title>
</head>
<body>
<div>
<img src="@Url.Action("ColumnChart")" alt="Column Chart using MVC" />
<br />
<img src="@Url.Action("BarChart")" alt="Bar Chart using MVC" />
</div>
</body>
</html>
Screenshot
You can also refer the below links.
