I have an insertparameter that is a non null nvarchar(MAX) and I set it using:
sds_accountDetail.InsertParameters["firstName"].DefaultValue = "";
But it still say "Cannot insert the value NULL into column 'firstName'", what am I doing wrong?
asked May 15, 2012 at 13:56
Bill Software Engineer
7,87024 gold badges109 silver badges192 bronze badges
2 Answers
I was just looking for a solution to this problem, and I encountered this page as the first Google result. I know the question is from 2012, but I decided to post for the sake of other people having the same problem. The "right" way of solving this is setting the ConvertEmptyStringToNull property of the problematic Parameter to false. It can be done in the .aspx file, like this:
<InsertParameters>
<!-- (...) -->
<asp:Parameter Name="firstName" ConvertEmptyStringToNull="false" />
<!-- (...) -->
</InsertParameters>
or in the code-behind, like this:
sds_accountDetail.InsertParameters["firstName"].ConvertEmptyStringToNull = false;
1 Comment
Bill Software Engineer
Excellent choice, I will mark this as the correct answer and use it in the future. Now after more than a year, the inferiority in using a white space to represent empty string is clear. This would have been a lot better.
"Solved" it by appending a space in the string:
sds_accountDetail.InsertParameters["firstName"].DefaultValue = " ";
answered May 15, 2012 at 14:09
Bill Software Engineer
7,87024 gold badges109 silver badges192 bronze badges
1 Comment
Limey
Remember, thats not a null though, it may allow your code to run, but you could end up with bad data once users start editing.
String.Emptyto see if that works? Like this:sds_accountDetail.InsertParameters["firstName"].DefaultValue = String.Empty;