Hi Ash,
I guess what u want to do is to change the rows to the columns and columns to rows and then bind to the datagrid. Here is a nice example that solves your problem:
http://www.codeproject.com/cs/database/Vertical_rows_in_Datagrid.asp

Signature
Bharat Biyani (bsb@orcim.com)
http://www.orcim.com
> Hi,
>
[quoted text clipped - 3 lines]
>
> Cheers