Hi,

There is a property "SortFieldsOnLoad" of the AdHoc control. If you set it to true (which is default), the fields will be sorted by field names. And if you set it to false, fields will come in the order of the Select query.

And if you set it to false and use "Select *", the fields will come in the physical order of database table (data source).