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

Question

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

Satyapriya Nayak · Answer

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

Dhanashri Patil · Answer

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

Dhanashri Patil · Answer

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

Dhanashri Patil · Answer

Thanks Satyapriya Nayak

Dhanashri Patil · Answer

Thanks but i am having sql database table can u help for coding how to do?

White Evaln · 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!