Show GridView Columns Horizontally and Vertically in ASP.Net

Hi fareed.fd7,

The links which you have shared for screenshot are not accessible please upload the screenshots to http://imgur.com/ and copy the link from Direct Link option and add to the screenshot in the editor.

How to add image or screenshot to the Editor

The currnet output

expecting output i need to display it like

What you are trying to do?

In both images first 4 records are same only in second image the rest two rows from first image is skipped.

Also the select statement you shared not related it with the same column name as its showing in images result.

in the first image

i have customer name, salespersonname, beat, orderno, orderdate, delivery date, itemcode,itemdesc,uom,quantity.

in the second image

i need show

customer name, salespersonname, beat, orderno, orderdate, delivery date, itemcode(item codes as header and below there i need show sold quantity),itemdesc(this column not neccessery),uom(this column not neccessery),quantity(this should come below of itemcode in grid).

customer name, salespersonname, beat, orderno, orderdate, delivery date - till this i need to show vertucally and remaing i  need to show horizontally.

consider i have table

customername,salesman,orderdate,delivery date, product,sold quantity

Ex:

 customername='x',salexman='a',orderdate='2017-11-30',deliverydate='orderdate='2017-11-30',product='abc',soldqty='100'

 customername='y',salexman='b',orderdate='2017-11-30',deliverydate='orderdate='2017-11-30',product='efg',soldqty='200'

the out put i'm expecting is

Note: here i'm using mysql database and the product  may differe and i will have n no of products