about displaying data in gridview

For that,

First Create Table

CREATE TABLE [classtimetable](

      [StaffId] [int] NULL,

      [ClassName] [varchar](50) NULL,

      [Subject] [varchar](50) NULL,

      [Days] [varchar](50) NULL,

      [time] [varchar](10) NULL,

      [PeriodNo] [int] NULL

) ON [PRIMARY]

After then Insert Value into this Table

Now using PIVOT Table you can easily Get Classwise TimeTable

SELECT time, PeriodNo, [Monday],[Tuesday],[WenesDay],[Thursday],[Friday],[Saturday]

FROM

(

SELECT sp.Days, sp.Subject+'('+CAST(sp.StaffId as varchar)+')' as ObjectName,sp.time,sp.PeriodNo

FROM classtimetable as sp where sp.ClassName='5A'

) p

PIVOT

(

MAX(ObjectName )

FOR Days

IN ([Monday],[Tuesday],[WenesDay],[Thursday],[Friday],[Saturday])

) AS pvt

Output : This TimeTable is for Std 5A Class.

() indicate Staff ID