Last post Jan 07, 2011 06:49 AM by Lyra Belaqua
Jan 07, 2011 06:35 AM|chambrick|LINK
I have a recordset in a gridview that comes from an outer joint that creates null values in the recordset
When I write to the database using stored proc defined in datasource I get dbnull error.
I'm trying to process the onDeleting event in the code behind but don't know what to write or if that's the best way
I need to call a stored proc and if the last parameters value is null then the stored proc does one thing, if it's no null it does something else.
However DBNull doesn't ssem to be working.
Jan 07, 2011 06:49 AM|Lyra Belaqua|LINK
You can use case statement for that purpose.
CASE WHEN FieldName IS NULL THEN 'Do task A' ELSE 'Do task B' END AS FieldName