You need to re-order the columns at dataset level, then re-open the dataset. As already mentioned, you cannot reorder the columns when using a database adapter.
I'm afraid your suggested procedure doesn't work. What works, however, is sorting the columns in the db adapter. If you then reassign the datasource in the adapter, the change is reflected in the grid. Thank you.