Transpose Dataset?

[Guest]

Hi,

I have an aspx page that queries and displays data from an Excel file.
However, the entries inside this Excel file are in columns instead of rows.
Is there anyway I can "transpose" the dataset with ASP.Net?

I know I can transpose the Excel file before uploading it, but I'd just like
to find out if it can be done in ASP.Net.

Thank you.

Regards,
WB

 

[Miha Markic [MVP C#]]

Hi,

You probably mean to transpose dataset using ado.net.
No, it is not possible out of the box.