>>Hi Rich,
>>
>>1. Try to set AutoPostBack property of the DropDown to true
>>
>Thanks for the reply. Unless the property is case-sensitive, AutoPostBack is being set to true.
>
>
>>2. If, for some unknown reason, declarative syntax would not work for you, you can always use code behind and selecting event of SQLDataSource to set your parameter.
>>
>These are training tools for me, not production code. So I have the luxury of trying to do it "right" rather than having to get it done now. My impression is that it is preferable to set up the parameterized query rather than trying to do it in code. Would you agree or do it differently?
>
>

Yes, declarative syntax in ASPX is supposed to work as well, I just gave an alternative solution in case it would not work for some unknown reason.


>>Check this blog
>>http://blogs.lessthandot.com/index.php/WebDev/WebDesignGraphicsStyling/setting-sqldatasource-parameter-from-the
>
>Thanks. I'll do that

Did you try to run SQL Profiler and check, what exactly is being sent to SQL Server? Perhaps there is some length mismatch or something along the lines?