Arrange Columns in a DataGridView

Question

I have a datagridview that is populated by a stored proc. Typically I would reorder the columns using the 'Edit Columns' dialog but this datagridview is being used to display data from different sources so I can't do that.

I have figured out how to rename the Headers and make certain columns Frozen but how do I change the display order on them?

Answer 1

 grid.AllowUserToOrderColumns = true;

Answer 2

Can you set the DisplayIndex for the columns?

Answer 3

With the DisplayIndex property

myGridView.Columns["myFirstCol"].DisplayIndex = 0;
myGridView.Columns["mySecondCol"].DisplayIndex = 1;