Asp.net MVC: display month wise data.

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sankara Krishnan Venugopal8y ago
Hi Rajesh,

You can use the below query to display whole April month list,

DECLARE @date DATE = '04/01/2018'
;WITH N(N)AS
(SELECT 1 FROM(VALUES(1),(1),(1),(1),(1),(1))M(N)),
tally(N)AS(SELECT ROW_NUMBER()OVER(ORDER BY N.N)FROM N,N a)
SELECT top(day(EOMONTH(@date)))
N day,
dateadd(d,N-1, @date) date
FROM tally

You can JOIN your table along with query.

I hope this helps.
0