ASP.NET Binding with EVAL

Question

Hi, I'm trying to do the following for asp.net combobox:

Text='<%# IIf(Eval("Name").ToString().Equals(""), Bind("Other"), Bind("Name") %>'  

What I'm trying to do is if the "Name" column is empty then bind to "Other" column, otherwise bind to "Name" column.

Anyone know the right syntax, keep getting object not set to reference. I'm doing this in VB.Net.

Thanks,
Jim

Answer 1

Try

Text='<%# IIf(Eval("Name").Equals(DBNull.Value), Eval("Other") , Eval("Name")) %>' 

Answer 2

Try this (Edited)

Text='<%# If(Not Eval("Name").ToString.Length = 0, Eval("Name") , Eval("Other")) %>' 

If this doesn't work, then you might have to build a Code Behind method

Text='<%# RetrieveName(Eval("Name"),Eval("Other"))'

Code Behind

Public Function RetrieveName(Byval name As String?, Byval other As String?) As String
  If Not String.IsDBNull(name) Then
    return name
  ElseIf String.IsDBNull(name) AndAlso Not String.IsDBNull(other) Then
    return other
  Else
    return String.Empty
  End If
End Function