I have a data table with a couple of fields (firstname, lastname). I am trying to create a third field with first and last name combined. The problem is sometimes the first name is null.
newcol.Expression = IIf(IsDBNull(m_Claim.polNameAddress.Columns("FldAddNameFirst")), "FldAddNameLast", "FldAddNameFirst + ' ' + FldAddNameLast")
I have the above code will always perform the the "else" part. Since the first name is null the value in the field I am binding too will show null instead of the last name.
Any ideas how to fix my problem?
MTmace
newcol.Expression = IIf(IsDBNull(m_Claim.polNameAddress.Columns("FldAddNameFirst")), "FldAddNameLast", "FldAddNameFirst + ' ' + FldAddNameLast")
I have the above code will always perform the the "else" part. Since the first name is null the value in the field I am binding too will show null instead of the last name.
Any ideas how to fix my problem?
MTmace