use a breakpoint to see if the text box value is parsed properly in the query. also, check the single and double quotes. they need to be in a proper sequence for the value to be fetched.

have u tried using static variables ?