1) When SqlParameter.IsNullable
is set to true
, received null
value is converted to DBNull.Value
and sent to database. Thus I would assume setting IsNullable
to true
only makes sense when GridView’s Parameter.ConvertEmptyStringToNull
is also set to true
?
2) Both GridView’s and ObjectDataSource’s parameters have a ConvertEmptyStringToNull
property. But is there ever a situation where ( when trying to update data source ):
• where we should set GridView’s Parameter.ConvertEmptyStringToNull
to true
, but then set ObjectDataSource’s Parameter.ConvertEmptyStringToNull
to false
?!
• or where we should set GridView’s Parameter.ConvertEmptyStringToNull
to true
, but SqlDataSource’s SqlParameter.IsNullable
to false
?