In order to do that you should subclass the cursoradapter class and trap the BeforecursorRefresh event. In the event handler you can change the SelectCmd property and the changed SelectCmd will be used to refresh the data.

Regards,
Chandra