>Or make an Extension Method so the usage is more fluent:
>
>> if (!tcValue.IsNullOrEmpty())
> {
> lcValue = tcValue;
> }
>I like that Mike ... don't know why I didn't think of making that an Extension method! Thanks!
~~Bonnie
>
>>I'd use the string.IsNullOrEmpty() method instead:
>>
>>
>> Public Function GetNonNullable(ByVal tcValue As String) As String
>> Dim lcValue As String= ""
>>
>> ' If we have a value
>> If Not string.IsNullOrEmpty(tcValue) Then
>> lcValue = tcValue
>> End If
>>
>> Return lcValue
>> End Function
>>
>>
>>~~Bonnie
>>
>>
>>>>In String you need to omit ?. String is not a simple type like integer, for example. So, you can pass null without declaring string?, just declare parameter as string.
>>>
>>>So, the adjustment I made is this:
>>>
>>>
>>> ' Avoid to receive a null
>>> ' expC1 Value
>>> Public Function GetNonNullable(ByVal tcValue As String) As String
>>> Dim lcValue As Integer = ""
>>>
>>> ' If we have a value
>>> If Not tcValue Is DBNull.Value Then
>>> lcValue = tcValue
>>> End If
>>>
>>> Return lcValue
>>> End Function
>>>
