Grid displaying data as a columns

[David Price]

Hello,

My objective is to use the Grid control to display data in columns going down rather than how its stored in the database in rows.

I have used an object to convert the data from row to columns. 

The data is dynamic so I don't know the column names until runtime

The object has three items

• ColumnName -  name of column
  
• DataItem - data for rows

The grid displays the first column 0 to show ColumnName then show DataItem. The last row shows the database ID to save data back to the database. 

Below is showing the data correctly. Test.aspx also displays data like this.

Issue 1:

The first row is showing the dynamic column names how can I hide the first row. Although css is hiding the column names in the example.

Issue 2:

The Grid Primary Key needs to be set to the last element which is shown as Database ID in the diagram above.

Issue 3:

I want to allow batch edit so I need to know the column name and the database ID to be able to commit the data back to the database in the code behind event. The examples on your site don't show how I can commit the data back to the database using batch edit in code behind.

Issue 4:

When the user is in grid edit mode I don't want them the ability to edit the column names which is column 0.

David

Attachment: Test.aspx_6d978707.zip