Simple answers. Now.
Create your parameter @MyParameter
add it to Text data source as Select * from Mytable where myvalue = (@MyParameter)