Also, if your DGV is bound at design time then you can use the DGV designer to arrange the columns. Also, you can open the dataset in the IDE and EDIT the TableAdapter SQL statement. Just right click on the tableadapter method you want to change and then select Configure. You can retrieve the ccolumns in any order you want.