Asp.net MVC: display month wise data.

Question

ASP.net MVC only:

I want to display all data what ever i select month.

 

if i select april month then display all record of april but in april 3 record only in database 1 april, 4 april, and 6 april but i want to display all date data what ever all date.

other date in automatically dispaly '0'.

 

Database:

Date	Student	Address	Cource	TIme
01/04/2018	Rajesh	Ahmedabad	CE	2hr
04/04/2018	Shailesh	Kadi	ME	1hr
06/04/2018	xyz	Rajkot	BE	3hr

 

 

OUTPUT: I want to OUTPUT like this in view.

 

Select Month:

April

 

Display all record from 1 april to 30 april 

Date	Student	Address	Cource	Time
01/04/2018	Rajesh	Ahmedabad	CE	2hr
02/04/2018	0	0	0	0
03/04/2018	0	0	0	0
04/04/2018	Shailesh	Kadi	ME	1hr
05/04/2018	0	0	0	0
06/04/2018	xyz	Rajkot	BE	3hr
07/04/2018	0	0	0	0
......	0	0	0	0
......	0	0	0	0
30/04/2018	0	0	0	0

if any idea or logic please tell me quickly.

 

Thank u