I finally read my Excel file, load it into a datagrid, define how the datagrid looks, adjust column names, width, etc. etc., the works.

But now I want the second column to be the first column, so;

ColumnA ColumnB ColumnC ColumnD

becomes

ColumnB ColumnA ColumnC ColumnD

When looking around the help files I get the following;

Using auto-generated columns is a quick and easy way to display information in the grid. Because these columns are automatically generated at run time and displayed in the order in which they occur in the data source, you do not have flexibility in how these columns are laid out.... ....You should explicitly define columns when you want to control which columns to display and in what order.

And you can do that with the autogeneratecolumn property of a datagrid.

Auto-Generated Columns
If the DataGrid control's AutoGenerateColumn property is set to true, the control will generate and display a bound column for each bindable column in the data source.

In other words, set datagridX.AutoGenerateColumn = false and define them yourself. Problem being, I don't see such a property anywhere.....

Do any of you? What am I missing here?

And any suggestions on how to switch the positions of my two columns?