Archive for the 'ASP' Category

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 [...]