FilterExpression in ASP.NET SqlDataSource

The FilterExpression tag in ASP.NET does not support the between operator. If you try to specify a clause like “between x and y” as your filter expression, you’ll get the error message:  The expression contains unsupported operator ‘Between’

ConvertEmptyStringToNull not working with ASP.NET SqlDataSource Parameters

The ConverEmptyStringToNull property of SqlDataSource Parameters does not work for asp.net 2.0 applications. You probably need this kind of setting when you have a stored procedure that can handle null as a valid parameter value, but the framework assumes nothing has been supplied and prevents the select/insert/update/delete statement from executing.