It should be doable using a DataTable. By loading a DataTable, you can copy
its contents to another DataTable by looping through columns and then rows,
rather than by rows and then columns.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Suresh" <an*******@discussions.microsoft.com> wrote in message
news:D8**********************************@microsof t.com...
There's no built in way for you to create pivot table for the thin client
using asp.net.
There are some third pary controls that can do this though.
Check out,
http://www.devexpress.com/products/n...xgrid/demo.asp
----- Ajay wrote: -----
Hello all,
I used to display reports in Excel earlier on my website. Now the
client has requested that he would like see reports in Pivot table on the
web . The backend is Sql2000. Can you please help in determining hoe we can
create a pivot table and display records in it using C#?
Thanks
Ajay