Display weekly Attendance in datagridview from Database

Question

 

 

 

 

hello!

 

i want to develop a dillay attendence software i  Display weekly Attendance in datagridview 

like

Date	11-10-2015	12-10-2015	13-10-2015	14-10-2015	15-10-2015	16-10-2015	17-10-2015
Attendance	OFF	P	A	P	-	-	-

 

what can i do???