"Like" query in adapter c#

Question

I have a data adapter that was created from my data set. i want to do this query:

Select Body WHERE Body Like '%@INPUTTEXT%'.

how can i do it? i want the "@INPUTTEXT" to be a parameter but because of the "' " it's a simple text...

Answer 1

WHERE BODY Like '%' + @inputtext + '%'