Rajesh Gami

Rajesh Gami

  • 72
  • 24.3k
  • 1.2m

Asp.net MVC: display month wise data.

May 18 2018 10:45 PM
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 CourceTIme
  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 
 DateStudentAddress 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
 
 
 

Answers (1)