crymedry

I have tried defining the variable and parameter in every way that I could think of.

How???

Take a look at this:

http://weblogs.asp.net/anasghanem/archive/2008/10/15/creating-custom-parameters-for-your-data-sources.aspx