Show Chart in MVC.

Question

I have two tables Course and Student , Course can have multiple students , in MVC view i have to show each course with respective number of Student, how to achieve this, any article or exmple please.

Sachin Singh · Answer

In MVC there is a chart Html helper, you can use that , follow below example , i have taken dummy data for student and courses public List GetChartData() { Course C1 = new Course() {Id=1,Name= "Asp.Net" }; Course C2 = new Course() { Id = 2, Name = "Java" }; Course C3 = new Course() {Id=3,Name= "C" }; Student s1= new Student() {Id=1,Name= "Shyam" ,course=C1 }; Student s2 = new Student() { Id = 2, Name = "Mohan" , course = C1 }; Student s3 = new Student() { Id = 3, Name = "Geetha" , course = C1 }; Student s4 = new Student() { Id = 4, Name = "Madhwan" , course = C2 }; Student s5 = new Student() { Id = 5, Name = "Vikash" , course = C3 }; Student s6 = new Student() { Id = 6, Name = "Jignesh" , course = C3 }; // Create two lists. List courses = new List (){C1,C2,C3 }; List students = new List () { s1, s2, s3, s4, s5,s6}; var query = (from course in courses join student in students on course equals student.course into gj select new ChartVM { CourseName = course.Name, StudentCount = gj.Count() }).ToList(); return query; } public class ChartVM { public string CourseName { get ; set ; } public int StudentCount { get ; set ; } } @{ var chart = new Chart(width: 500, height: 500, theme: ChartTheme.Yellow) .AddTitle( "Course Vs Students" ) .AddSeries( "Default" , chartType: "Bar" , xValue: Model, xField: "CourseName" , yValues: Model, yFields: "StudentCount" ) .Write(); }

Puja Aggarwal · Answer

Thank you so much.