Populate Chart Control from Database in ASP.Net MVC

Question

Hello sirI want to crete charts in mvc 4 by taking data from sql database please help me

dharmendr · Accepted Answer

Hi  nikita16I have created sample in MVC using EntityFramework by refering the below articleCreate Organizational Chart from Database using Google Organizational Chart in ASPNetSQL12345678910111213141516171819202122CREATE TABLE dboEmployeesHierarchy    EmployeeId int IDENTITY11 NOT NULL    Name varchar100 NULL    Designation varchar30 NULL    ReportingManager int NULL ON PRIMARY GOSET ANSIPADDING OFFGOSET IDENTITYINSERT dboEmployeesHierarchy ON INSERT dboEmployeesHierarchy VALUES 1 NNancy Davolio NSales Representative 5INSERT dboEmployeesHierarchy VALUES 2 NAndrew Fuller NCEO 3INSERT dboEmployeesHierarchy VALUES 3 NJanet Leverling NMD NULLINSERT dboEmployeesHierarchy VALUES 4 NMargaret Peacock NSales Representative 5INSERT dboEmployeesHierarchy VALUES 5 NSteven Buchanan NSales Manager 2INSERT dboEmployeesHierarchy VALUES 6 NMichael Suyama NSales Representative

dharmendr · Answer

HiI have created sample using entity framework Refer the below codeSQLCREATE TABLE dbotblMVCCharts ID int IDENTITY11 NOT NULL Year int NULL Value float NULL ON PRIMARY  INSERT INTO tblMVCCharts Year Value VALUES 200850INSERT INTO tblMVCCharts Year Value VALUES 200970INSERT INTO tblMVCCharts Year Value VALUES 201080INSERT INTO tblMVCCharts Year Value VALUES 201190INSERT INTO tblMVCCharts Year Value VALUES 2012120INSERT INTO tblMVCCharts Year Value VALUES 2013150INSERT INTO tblMVCCharts Year Value VALUES 2014100INSERT INTO tblMVCCharts Year Value VALUES 2015300NameSpaces using SystemWebHelpersusing SystemWebMvcusing SystemCollectionsusing SystemCollectionsGenericControllerstatic practiceEntities pe  new practiceEntitiesArrayList xValue  new ArrayListArrayList yValue  new ArrayList GET Homepublic ActionResult Index    return Viewpublic ActionResult ColumnChart

Populate Chart Control from Database in ASP.Net MVC

Create Organizational Chart from Database using Google Organizational Chart in ASP.Net

Company

Explore

Follow us

Contact Us