Change text in ListView if Null RSS

• • Reply
  

  oned_gk

  All-Star

  31818 Points

  6509 Posts

  Re: Change text in ListView if Null

  Dec 21, 2012 11:24 PM|LINK

  Text='<%# IIF(isdbnull(Eval ("ASSIGNEE")),"unassigned","assigned") %>'

  Programming to simplify, dont look for hard way
  • Edited by oned_gk on Dec 23, 2012 01:14 AM
  • Edited by oned_gk on Dec 23, 2012 01:14 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Change text in ListView if Null

  Dec 22, 2012 03:00 AM|LINK

  n2netwrkng

  n2netwrkng

  Hi,

  What kind of datasource it is?

  A DataTable or a List<T>?

  Or something else?

• • Reply
  

  n2netwrkng

  Member

  26 Points

  61 Posts

  Re: Change text in ListView if Null

  Dec 22, 2012 12:14 PM|LINK

  It's an MS Access DB.

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Change text in ListView if Null

  Dec 23, 2012 12:49 AM|LINK

  n2netwrkng

  It's an MS Access DB.

  Hi,

  You can define a function to check whether you've got a value or not:

  <asp:label id="ASSIGNEELabel" runat="server" Text='<%#Func(Eval("ASSIGNEE"))%>'/>

  And your Func should be:

  Public Function Func(object value) As String
     If (value Is Nothing OrElse value.ToString().Trim()="") Then
        Return value.ToString() & ":"
     End If
     Return String.Empty
  End Function

  • Edited by decker dong - msft on Dec 23, 2012 01:54 AM
  • Edited by decker dong - msft on Dec 27, 2012 02:53 AM
  • Edited by n2netwrkng on Jan 11, 2013 01:36 PM
• • Reply
  

  n2netwrkng

  Member

  26 Points

  61 Posts

  Re: Change text in ListView if Null

  Jan 11, 2013 01:36 PM|LINK

  I get the following compiler error:

  Compiler Error Message: BC30183: Keyword is not valid as an identifier.

  Line 25: End If
  Line 26: End Sub
  Line 27: Public Function Func(object value) As String
  Line 28:    If (value Is Nothing OrElse value.ToString().Trim()="") Then
  Line 29:       Return value.ToString() & ":"

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Change text in ListView if Null

  Jan 12, 2013 01:52 AM|LINK

  n2netwrkng

  Line 27: Public Function Func(object value) As String

  Hi,

  You can try to change to this:

  Public Function MyFunc(object value) As String
     If (value Is Nothing OrElse value.ToString().Trim()="") Then
        Return value.ToString() & ":"
     End If
     Return String.Empty
  End Function

  And then change to this:

  <asp:label id="ASSIGNEELabel" runat="server" Text='<%#MyFunc(Eval("ASSIGNEE"))%>'/

• • Reply
  

  n2netwrkng

  Member

  26 Points

  61 Posts

  Re: Change text in ListView if Null

  Jan 15, 2013 06:04 PM|LINK

  I get the same error.  Could I do this in a VB subroutine somehow?

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Change text in ListView if Null

  Jan 16, 2013 12:19 AM|LINK

  n2netwrkng

  I get the same error.  Could I do this in a VB subroutine somehow?

  Hi again，

  You can try this：

  Public Function Func(value As Object) As String
          If (value Is Nothing OrElse value.ToString().Trim() = "") Then
              Return value.ToString() & ":"
          End If
          Return String.Empty
      End Function

• • Reply
  

  oned_gk

  All-Star

  31818 Points

  6509 Posts

  Re: Change text in ListView if Null

  Jan 16, 2013 12:26 AM|LINK

  Text='<%# IIF(isdbnull(Eval("ASSIGNEE")),"unassigned",Eval("ASSIGNEE")) %>'

  Programming to simplify, dont look for hard way
  • Marked as answer by n2netwrkng on Jan 28, 2013 02:25 PM
• • Reply
  

  n2netwrkng

  Member

  26 Points

  61 Posts

  Re: Change text in ListView if Null

  Jan 28, 2013 02:26 PM|LINK

  That worked, thank you so much.