showing single gridview in both horizontal and vertical

Question

how to show a single gridview both veritcally and horizontally

means some columns should be vertically and some are in horizontally.

Ex:

Order Id|CustomerName|Productname1|productName2

Ex:

OrderId | CustomerName|pens| pencils|notes

1 xyz 5 6 2

Revathi Parvathi · Answer

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

fareed fd · Answer

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 idcustomerName  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.

Revathi Parvathi · Answer

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.

Esakki Muthu · Answer

Can you please give more information / your code ? I'm unable to understand your question