objectdatasource to have a parameterized query

See more:

All-Topics

SELECT ElementID, ElementDescription, ElementLiqAFactor, ElementGasAFactor, ElementMetalElements, 
   ElementELM, ElementMediaMFR, ElementAdaptorMFR, 
   ElementDateStamp, ElementMaint
FROM  TSElements
WHERE (ElementDescription LIKE %claris%)

This is the sql command I am using and I want it to be parameterized i.e. only the %claris% needs to be parameterized. I am using objectdatasource and all the sql functions are present in the xsd file.

Let me know if you have any ideas. Thanks.