How to change data binding from left to right in Asp.net table?

Normally Table data bind from top to bottom with column headers at the top of开发者_如何学Go the table.Is there way to change the data binding from left to right and headers in the first column of the table?

---

You can't automatically' do this is asp.net. You need to transform/pivot your data into the form you need. This is also called a crosstab report.

There are a few options:

1. DIY - Loop through the rows in your source data and manually transform it.

2. Do the pivot in SQL Server. Here is a simple example on SO.

3. Use a 3rd-party pivot table control to do the hard work for you. eg Devexpress has fantastic asp.net pivottable control. There are other out there too. Unfortunately they are not free.