By the way, the same error occurs in your Sample Application if you click on the column header twice to sort Descending. If the 4th order on the list is being displayed, when sorted Ascending, the list displays the 4th order from the bottom of the list when sorted Descending. However, the error message from your sample app is different:

ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.