Changeable Columns in Datagrid?

[Cin0s3]

I am using a datagrid to display 10 fields from the database which has 250 fields, if the user wants to change one of the columns to something else in the database can this be done by having a dropdown box as the header? Or is there anyother way to do this?

[fungi]

You could have some sort of mechanism to let the user map columns to data fields. They click refresh or something and then the mapping data is used to build the SQL statement.

At first I considered having a drop down in each column of the resultset header row but a drop down isn't a good way to show 250 values.

Hope this helps.