insert database table column value in grid row how can it do?

insert database table column value in grid row how can it do? for eg.

time
9.00-10.00
10.00-11.00
11.00-12.00
12.00-1.00

it should store like

9.00-10.00	10.00-11.00	11.00-12.00	12.00-1.00

Now i want that other data from database insert vertically can you help me?


for eg.

time                         Subject1        subject2
9.00-10.00                eng                math
10.00-11.00                math                eng
11.00-12.00                sci                        gro        
12.00-1.00                Mar                        mar

it should  store like

9.00-10.00	10.00-11.00	11.00-12.00	12.00-1.00
eng	math
math	eng
sci	gro
mar	mar

plz help me

Now i want to add mutiple values in on cell how can do this can you help me?

Thanks Satyapriya Nayak

Hi Dhanashri,


Please refer the below link

http://www.c-sharpcorner.com/UploadFile/1a81c5/display-columns-as-rows-in-gridview-in-Asp-Net/

Thanks
If this post helps you mark it as answer

you can copy column cell data to row and delete the original data

worksheet.Copy(worksheet.Range["A2:A4"],worksheet.Range["B1:D1"],true);

and delete the orignal data:

              //delete cell data A2 but not its format
            worksheet.Range["A2"].Clear(ExcelClearOptions.ClearContent);
               //delete the format of A2
            worksheet.Range["A2"].Clear(ExcelClearOptions.ClearFormat);
            //delete cell data A2 including its format
            worksheet.Range["A2"].Clear(ExcelClearOptions.ClearAll);

see details at Excel Data Setup C#. Hope it can help you!