When using the TTMSFNCGridDatabaseAdapter as-is, the grid displays the connected dataset and sorting is supposed to happen on the dataset. The grid will always reflect the sorted dataset.
If for some reason, you cannot sort the dataset, you can have the grid display & sort the data by calling
TTMSFNCGridDatabaseAdapter.LoadAllDataAndDisconnect
After this, the regular sorting functions on the grid itself will work.
After this, the regular sorting functions on the grid itself will work.