ASP.net VB.net show dates across top of GridView

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

In my ASP.net web app I pull data through to a GridView. One of the columns is  Date column.I have now been asked
to show the data with the dates along the top horizontally as opposed to vertically in a column. How would I go about this?
The image shows the dates at the top.

1Image1.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Obadiah ChristopherDeveloper User Interface

Commented:
Are you retrieving data in a datatable?
Murray BrownASP.net/VSTO Developer

Author

Commented:
Hi. Yes I am
i have something similar to display an annual leave chart.
but it  is probably not very efficient... as it is built by separate queries for header and then for each row.  (as the page was created in 2002)

maybe able to use new SQL2005  CrossTab  https://www.essentialsql.com/create-cross-tab-query-summarize-data-sql-server/


but given the formatting you appear to want , it may be simpler to just build each row and add to grid 'manually'
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks for the help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial