I wan the REPORT FAculty and Course wise in data grid view 2
output as follows in data grid view 1
Date Session RK CMK CNN Gs VB JN (Faculty Name)
7/1/2013 1 REO PH2 REO TAS AM VH
7/1/2013 2 PH2 AM TAs AM VH REO
7/1/2013 3 AM TAs REO PH2 VH TAS
8/1/2013 1 PH2 REO TAS VH AM PH2
8/1/2013 2 AM PH2 REO AM VH TAs
8/1/2013 3 TAs AM VH REO VH PH2
i want the report which faculty has taken course on date and session wise ;
for example RK(Faculty Name)
i want output as follows in data grid view 2 ; RK(Faculty Name) from the data grid view 1
Date Session Course
7/1/2013 1 REO
7/1/2013 2 PH2
7/1/2013 3 AM
8/1/2013 1 PH2
8/1/2013 2 AM
8/1/2013 3 TAs