showing single gridview in both horizontal and vertical

Hi,

 

Use pivot concept in SQL.We can use datavalue as header (table column). 

hi sir

 

see i need show some data of database in gridveiw and that gridview has be in both verticall and horizontal 

 

for example

 

the consider i'm fetching the data from the database is id,customerName , product, qty.

 

so i need show it as 

orderId customerName Product1 Product2

1               xyz                      5            3

 

 

 

in above example the orderId and customerName both are headerText but the product1, Product2 are the databse values that i need to show it in header text.

above values are respective that order.

Hi,

 

select the grid view and right click and go to properties.Choose the both in Gridlines.For Example, see the below-mentioned screen shot.