Populate duty roster using GridView in asp.net using c#

Question

I want to display duty roster weekly using GridView in asp.net using c#

 

My database table:

 

 

 Entry Shift Allocation:

 

 

 

Then I want to display weekly roster in Gridview as below

Category	Name	Mon 15/6	Tue 16/6	Wed 17/6	Thu 18/6	Fri 19/6	Sat 20/6	Sun 21/6
ENT	Dr.A. Das		Morning 8am-11am		Morning 9am-12pm			After Noon 5pm-8pm
ENT	Dr.Bera	Morning 7am-10am	After Noon 4pm-7pm			Morning 8am-11am

Please help me.