ASP.NET, SQLDataSources, and null parameters
Friday, September 5th, 2008
Using a stored procedure in your SQLDataSource? Good! Trying to pass blank parameters? Trouble! If your stored procedure needs to be able to accept null values or blank strings, set the CancelSelectOnNullParameter property of the data source to false. Otherwise, passing an empty value to a parameter will cancel your data access, leaving you wondering [...]