<p>Hi is it possible to use a variable for&nbsp;theCommandText?</p><p>My issue is that I want to filter items based on price high/low or duration high/low.</p><p>My example is here:<br><a href="http://realrussia.co.uk/test/test-excursions/City?City=Moscow">http://realrussia.co.uk/test/test-excursions/City?...</a><br>I intend on adding 2 radio buttons or tick boxes that allow the options mentioned above.<br><br>I would reload the page so that's not an issue but I need to be able to&nbsp;change the "duration" and "Price" in my SQL:<br>"ORDER BY duration,price&nbsp;ASC".</p><p>I can't see any way of doing this currently.</p><p>I hope this makes sense?</p><p>Thanks<br>Harry</p>